Кто-то знает кде еще можно достать размер оперативы кроме вьюшки SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory ?

Physical memory Array если есть

КАС! 12 праймари! 120 вторичек и 360 ДП!

И можно ли, если делаем реплику, в регионе поставить sms provider и цепляться консолью к реплике?

https://vanyurikhin.blog/2019/08/13/intune-macos/

@masyan уже и из под бота пишешь))

https://vanyurikhin.blog/2019/08/13/intune-macos/

https://vanyurikhin.blog/2019/08/13/intune-macos/

на новом маке при входе пароль для кейчейна станет паролем первого входа, а если учетка адшная и у вас смена паролей каждые 60 дней, то через год может быть прикольно )

Когда дата релиза?

функциональность

как очистить недавние?

Ну спрячь целое меню

Здравствуйте.Есть идеи, как победить?

Откройте уже кейс)

Откройте уже кейс)

Здравствуйте.Есть идеи, как победить?

Простите, не понял)

Простите, не понял)

Пришлите, что написано в *** CREATE....

Контракт премьер поддержки есть? :)

*** CREATE PROCEDURE dbo.pOperating_System_DATA @Pragma int ,@MachineID int ,@TimeKey datetime ,@AgentID int ,@BootDevice00 nvarchar(255) =NULL,@BuildNumber00 nvarchar(255) =NULL,@BuildType00 nvarchar(255) =NULL,@Caption00 nvarchar(255) =NULL,@CodeSet00 nvarchar(255) =NULL,@CountryCode00 nvarchar(255) =NULL,@CSDVersion00 nvarchar(255) =NULL,@CurrentTimeZone00 int =NULL,@Debug00 int =NULL,@Description00 nvarchar(255) =NULL,@Distributed00 int =NULL,@ForegroundApplicationBoost00 int =NULL,@FreePhysicalMemory00 bigint =NULL,@FreeSpaceInPagingFiles00 bigint =NULL,@FreeVirtualMemory00 bigint =NULL,@InstallDate00 datetime =NULL,@LastBootUpTime00 datetime =NULL,@LocalDateTime00 datetime =NULL,@Locale00 nvarchar(255) =NULL,@Manufacturer00 nvarchar(255) =NULL,@MaxNumberOfProcesses00 int =NULL,@MaxProcessMemorySize00 bigint =NULL,@MUILanguages00 nvarchar(255) =NULL,@Name00 nvarchar(255),@NumberOfLicensedUsers00 int =NULL,@NumberOfProcesses00 int =NULL,@NumberOfUsers00 int =NULL,@OperatingSystemSKU00 int =NULL,@Organization00 nvarchar(255) =NULL,@OSArchitecture00 nvarchar(255) =NULL,@OSLanguage00 int =NULL,@OSProductSuite00 int =NULL,@OSType00 int =NULL,@OtherTypeDescription00 nvarchar(255) =NULL,@PlusProductID00 nvarchar(255) =NULL,@PlusVersionNumber00 nvarchar(255) =NULL,@Primary00 int =NULL,@ProductType00 int =NULL,@RegisteredUser00 nvarchar(255) =NULL,@SerialNumber00 nvarchar(255) =NULL,@ServicePackMajorVersion00 int =NULL,@ServicePackMinorVersion00 int =NULL,@SizeStoredInPagingFiles00 bigint =NULL,@Status00 nvarchar(255) =NULL,@SystemDevice00 nvarchar(255) =NULL,@SystemDirectory00 nvarchar(255) =NULL,@TotalSwapSpaceSize00 bigint =NULL,@TotalVirtualMemorySize00 bigint =NULL,@TotalVisibleMemorySize00 bigint =NULL,@Version00 nvarchar(255) =NULL,@WindowsDirectory00 nvarchar(255) =NULL AS ~ BEGIN ~ set nocount on ~ declare @RevisionID int, @InstanceKey int, @ExTimeKey datetime, @Deleted int ~ select @Deleted = 0 ~ select @InstanceKey = InstanceKey, @RevisionID = RevisionID, @ExTimeKey = TimeKey ~ from Operating_System_DATA ~ where MachineID = @MachineID and Name00 = @Name00~ IF (isnull(@InstanceKey,0) != 0) ~ BEGIN ~ IF EXISTS ~ ( ~ select MachineID from Operating_System_DATA~ where InstanceKey = @InstanceKey and MachineID = @MachineID and BootDevice00 = @BootDevice00 and BuildNumber00 = @BuildNumber00 and BuildType00 = @BuildType00 and Caption00 = @Caption00 and CodeSet00 = @CodeSet00 and CountryCode00 = @CountryCode00 and CSDVersion00 = @CSDVersion00 and CurrentTimeZone00 = @CurrentTimeZone00 and Debug00 = @Debug00 and Description00 = @Description00 and Distributed00 = @Distributed00 and ForegroundApplicationBoost00 = @ForegroundApplicationBoost00 and FreePhysicalMemory00 = @FreePhysicalMemory00 and FreeSpaceInPagingFiles00 = @FreeSpaceInPagingFiles00 and FreeVirtualMemory00 = @FreeVirtualMemory00 and InstallDate00 = @InstallDate00 and LastBootUpTime00 = @LastBootUpTime00 and LocalDateTime00 = @LocalDateTime00 and Locale00 = @Locale00 and Manufacturer00 = @Manufacturer00 and MaxNumberOfProcesses00 = @MaxNumberOfProcesses00 and MaxProcessMemorySize00 = @MaxProcessMemorySize00 and MUILanguages00 = @MUILanguages00 and Name00 = @Name00 and NumberOfLicensedUsers00 = @NumberOfLicensedUsers00 and NumberOfProcesses00 = @NumberOfProcesses00 and NumberOfUsers00 = @NumberOfUsers00 and OperatingSystemSKU00 = @OperatingSystemSKU00 and Organization00 = @Organization00 and OSArchitecture00 = @OSArchitecture00 and OSLanguage00 = @OSLanguage00 and OSProductSuite00 = @OSProductSuite00 and OSType00 = @OSType00 and OtherTypeDescription00 = @OtherTypeDescription00 and PlusProductID00 = @PlusProductID00 and PlusVersionNumber00 = @PlusVersionNumber00 and Primary00 = @Primary00 and ProductType00 = @ProductType00 and RegisteredUser00 = @RegisteredUser00 and SerialNumber00 = @SerialNumber00 and ServicePackMajorVersion00 = @ServicePackMajorVersion00 and ServicePackMinorVersion00 = @ServicePackMinorVersion00 and SizeStoredInPagingFiles00 = @SizeStoredInPagingFiles00 and Status00 = @Status00 and SystemD

*** CREATE PROCEDURE dbo.pOperating_System_DATA @Pragma int ,@MachineID int ,@TimeKey datetime ,@AgentID int ,@BootDevice00 nvarchar(255) =NULL,@BuildNumber00 nvarchar(255) =NULL,@BuildType00 nvarchar(255) =NULL,@Caption00 nvarchar(255) =NULL,@CodeSet00 nvarchar(255) =NULL,@CountryCode00 nvarchar(255) =NULL,@CSDVersion00 nvarchar(255) =NULL,@CurrentTimeZone00 int =NULL,@Debug00 int =NULL,@Description00 nvarchar(255) =NULL,@Distributed00 int =NULL,@ForegroundApplicationBoost00 int =NULL,@FreePhysicalMemory00 bigint =NULL,@FreeSpaceInPagingFiles00 bigint =NULL,@FreeVirtualMemory00 bigint =NULL,@InstallDate00 datetime =NULL,@LastBootUpTime00 datetime =NULL,@LocalDateTime00 datetime =NULL,@Locale00 nvarchar(255) =NULL,@Manufacturer00 nvarchar(255) =NULL,@MaxNumberOfProcesses00 int =NULL,@MaxProcessMemorySize00 bigint =NULL,@MUILanguages00 nvarchar(255) =NULL,@Name00 nvarchar(255),@NumberOfLicensedUsers00 int =NULL,@NumberOfProcesses00 int =NULL,@NumberOfUsers00 int =NULL,@OperatingSystemSKU00 int =NULL,@Organization00 nvarchar(255) =NULL,@OSArchitecture00 nvarchar(255) =NULL,@OSLanguage00 int =NULL,@OSProductSuite00 int =NULL,@OSType00 int =NULL,@OtherTypeDescription00 nvarchar(255) =NULL,@PlusProductID00 nvarchar(255) =NULL,@PlusVersionNumber00 nvarchar(255) =NULL,@Primary00 int =NULL,@ProductType00 int =NULL,@RegisteredUser00 nvarchar(255) =NULL,@SerialNumber00 nvarchar(255) =NULL,@ServicePackMajorVersion00 int =NULL,@ServicePackMinorVersion00 int =NULL,@SizeStoredInPagingFiles00 bigint =NULL,@Status00 nvarchar(255) =NULL,@SystemDevice00 nvarchar(255) =NULL,@SystemDirectory00 nvarchar(255) =NULL,@TotalSwapSpaceSize00 bigint =NULL,@TotalVirtualMemorySize00 bigint =NULL,@TotalVisibleMemorySize00 bigint =NULL,@Version00 nvarchar(255) =NULL,@WindowsDirectory00 nvarchar(255) =NULL AS ~ BEGIN ~ set nocount on ~ declare @RevisionID int, @InstanceKey int, @ExTimeKey datetime, @Deleted int ~ select @Deleted = 0 ~ select @InstanceKey = InstanceKey, @RevisionID = RevisionID, @ExTimeKey = TimeKey ~ from Operating_System_DATA ~ where MachineID = @MachineID and Name00 = @Name00~ IF (isnull(@InstanceKey,0) != 0) ~ BEGIN ~ IF EXISTS ~ ( ~ select MachineID from Operating_System_DATA~ where InstanceKey = @InstanceKey and MachineID = @MachineID and BootDevice00 = @BootDevice00 and BuildNumber00 = @BuildNumber00 and BuildType00 = @BuildType00 and Caption00 = @Caption00 and CodeSet00 = @CodeSet00 and CountryCode00 = @CountryCode00 and CSDVersion00 = @CSDVersion00 and CurrentTimeZone00 = @CurrentTimeZone00 and Debug00 = @Debug00 and Description00 = @Description00 and Distributed00 = @Distributed00 and ForegroundApplicationBoost00 = @ForegroundApplicationBoost00 and FreePhysicalMemory00 = @FreePhysicalMemory00 and FreeSpaceInPagingFiles00 = @FreeSpaceInPagingFiles00 and FreeVirtualMemory00 = @FreeVirtualMemory00 and InstallDate00 = @InstallDate00 and LastBootUpTime00 = @LastBootUpTime00 and LocalDateTime00 = @LocalDateTime00 and Locale00 = @Locale00 and Manufacturer00 = @Manufacturer00 and MaxNumberOfProcesses00 = @MaxNumberOfProcesses00 and MaxProcessMemorySize00 = @MaxProcessMemorySize00 and MUILanguages00 = @MUILanguages00 and Name00 = @Name00 and NumberOfLicensedUsers00 = @NumberOfLicensedUsers00 and NumberOfProcesses00 = @NumberOfProcesses00 and NumberOfUsers00 = @NumberOfUsers00 and OperatingSystemSKU00 = @OperatingSystemSKU00 and Organization00 = @Organization00 and OSArchitecture00 = @OSArchitecture00 and OSLanguage00 = @OSLanguage00 and OSProductSuite00 = @OSProductSuite00 and OSType00 = @OSType00 and OtherTypeDescription00 = @OtherTypeDescription00 and PlusProductID00 = @PlusProductID00 and PlusVersionNumber00 = @PlusVersionNumber00 and Primary00 = @Primary00 and ProductType00 = @ProductType00 and RegisteredUser00 = @RegisteredUser00 and SerialNumber00 = @SerialNumber00 and ServicePackMajorVersion00 = @ServicePackMajorVersion00 and ServicePackMinorVersion00 = @ServicePackMinorVersion00 and SizeStoredInPagingFiles00 = @SizeStoredInPagingFiles00 and Status00 = @Status00 and SystemD

на гист скопипастни

подскажите каталог программ с уже готовыми ключами тихой установки. Когда-то кто-то тут его скидывал

открываешь документацию приложений и смотришь

на гист скопипастни

https://gist.github.com/

*** CREATE PROCEDURE dbo.pOperating_System_DATA @Pragma int ,@MachineID int ,@TimeKey datetime ,@AgentID int ,@BootDevice00 nvarchar(255) =NULL,@BuildNumber00 nvarchar(255) =NULL,@BuildType00 nvarchar(255) =NULL,@Caption00 nvarchar(255) =NULL,@CodeSet00 nvarchar(255) =NULL,@CountryCode00 nvarchar(255) =NULL,@CSDVersion00 nvarchar(255) =NULL,@CurrentTimeZone00 int =NULL,@Debug00 int =NULL,@Description00 nvarchar(255) =NULL,@Distributed00 int =NULL,@ForegroundApplicationBoost00 int =NULL,@FreePhysicalMemory00 bigint =NULL,@FreeSpaceInPagingFiles00 bigint =NULL,@FreeVirtualMemory00 bigint =NULL,@InstallDate00 datetime =NULL,@LastBootUpTime00 datetime =NULL,@LocalDateTime00 datetime =NULL,@Locale00 nvarchar(255) =NULL,@Manufacturer00 nvarchar(255) =NULL,@MaxNumberOfProcesses00 int =NULL,@MaxProcessMemorySize00 bigint =NULL,@MUILanguages00 nvarchar(255) =NULL,@Name00 nvarchar(255),@NumberOfLicensedUsers00 int =NULL,@NumberOfProcesses00 int =NULL,@NumberOfUsers00 int =NULL,@OperatingSystemSKU00 int =NULL,@Organization00 nvarchar(255) =NULL,@OSArchitecture00 nvarchar(255) =NULL,@OSLanguage00 int =NULL,@OSProductSuite00 int =NULL,@OSType00 int =NULL,@OtherTypeDescription00 nvarchar(255) =NULL,@PlusProductID00 nvarchar(255) =NULL,@PlusVersionNumber00 nvarchar(255) =NULL,@Primary00 int =NULL,@ProductType00 int =NULL,@RegisteredUser00 nvarchar(255) =NULL,@SerialNumber00 nvarchar(255) =NULL,@ServicePackMajorVersion00 int =NULL,@ServicePackMinorVersion00 int =NULL,@SizeStoredInPagingFiles00 bigint =NULL,@Status00 nvarchar(255) =NULL,@SystemDevice00 nvarchar(255) =NULL,@SystemDirectory00 nvarchar(255) =NULL,@TotalSwapSpaceSize00 bigint =NULL,@TotalVirtualMemorySize00 bigint =NULL,@TotalVisibleMemorySize00 bigint =NULL,@Version00 nvarchar(255) =NULL,@WindowsDirectory00 nvarchar(255) =NULL AS ~ BEGIN ~ set nocount on ~ declare @RevisionID int, @InstanceKey int, @ExTimeKey datetime, @Deleted int ~ select @Deleted = 0 ~ select @InstanceKey = InstanceKey, @RevisionID = RevisionID, @ExTimeKey = TimeKey ~ from Operating_System_DATA ~ where MachineID = @MachineID and Name00 = @Name00~ IF (isnull(@InstanceKey,0) != 0) ~ BEGIN ~ IF EXISTS ~ ( ~ select MachineID from Operating_System_DATA~ where InstanceKey = @InstanceKey and MachineID = @MachineID and BootDevice00 = @BootDevice00 and BuildNumber00 = @BuildNumber00 and BuildType00 = @BuildType00 and Caption00 = @Caption00 and CodeSet00 = @CodeSet00 and CountryCode00 = @CountryCode00 and CSDVersion00 = @CSDVersion00 and CurrentTimeZone00 = @CurrentTimeZone00 and Debug00 = @Debug00 and Description00 = @Description00 and Distributed00 = @Distributed00 and ForegroundApplicationBoost00 = @ForegroundApplicationBoost00 and FreePhysicalMemory00 = @FreePhysicalMemory00 and FreeSpaceInPagingFiles00 = @FreeSpaceInPagingFiles00 and FreeVirtualMemory00 = @FreeVirtualMemory00 and InstallDate00 = @InstallDate00 and LastBootUpTime00 = @LastBootUpTime00 and LocalDateTime00 = @LocalDateTime00 and Locale00 = @Locale00 and Manufacturer00 = @Manufacturer00 and MaxNumberOfProcesses00 = @MaxNumberOfProcesses00 and MaxProcessMemorySize00 = @MaxProcessMemorySize00 and MUILanguages00 = @MUILanguages00 and Name00 = @Name00 and NumberOfLicensedUsers00 = @NumberOfLicensedUsers00 and NumberOfProcesses00 = @NumberOfProcesses00 and NumberOfUsers00 = @NumberOfUsers00 and OperatingSystemSKU00 = @OperatingSystemSKU00 and Organization00 = @Organization00 and OSArchitecture00 = @OSArchitecture00 and OSLanguage00 = @OSLanguage00 and OSProductSuite00 = @OSProductSuite00 and OSType00 = @OSType00 and OtherTypeDescription00 = @OtherTypeDescription00 and PlusProductID00 = @PlusProductID00 and PlusVersionNumber00 = @PlusVersionNumber00 and Primary00 = @Primary00 and ProductType00 = @ProductType00 and RegisteredUser00 = @RegisteredUser00 and SerialNumber00 = @SerialNumber00 and ServicePackMajorVersion00 = @ServicePackMajorVersion00 and ServicePackMinorVersion00 = @ServicePackMinorVersion00 and SizeStoredInPagingFiles00 = @SizeStoredInPagingFiles00 and Status00 = @Status00 and SystemD

А то мне пока некогда смотреть что внутре )

SELECT u.name + '.' + t.name AS [table], td.value AS [table_desc], c.name AS [column], cd.value AS [column_desc] FROM sysobjects t INNER JOIN sysusers u ON u.uid = t.uid LEFT OUTER JOIN sys.extended_properties td ON td.major_id = t.id AND td.minor_id = 0 AND td.name = 'MS_Description' INNER JOIN syscolumns c ON c.id = t.id LEFT OUTER JOIN sys.extended_properties cd ON cd.major_id = c.id AND cd.minor_id = c.colid AND cd.name = 'MS_Description' WHERE t.type = 'u' AND t.name = 'Operating_System_DATA' ORDER BY t.name, c.colorder