Compare Windows 8.1 Editions

http://www.microsoft.com/en-us/windows/enterprise/products-and-technologies/windows-8-1/compare/default.aspx

SCCM Collection Query - All Windows 7 Clients

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Name like "Microsoft Windows 7%"

HP BIOS Configuration Utility

Mit folgendem Tool können HP BIOS Konfigurationen automatisiert über Command Line gesetzt werden:

http://h20331.www2.hp.com/Hpsub/us/en/bios-conf.html

Beispiel Boot Order:
BiosConfigUtility.exe /SetConfig:BootOrder.txt

BootOrder.txt:
Boot Order
 Hard Drive(C:)
 Notebook Upgrade Bay
 USB Floppy
 USB CD-ROM
 USB Hard Disk
 Network Controller
 SD Card
 Dock Upgrade Bay



Für die Aktivierung von TPM muss zumindest temporär ein BIOS PW gesetzt sein.

Beispiel TPM Aktivierung 8540p:
BiosConfigUtility.exe /setconfig:TPM.txt /nspwd:"mypassword"BiosConfigUtility.exe /cspwd:"mypassword" /nspwd:""

TPM.txt:
English
Activate Embedded Security On Next Boot
 Disable
 *Enable
Embedded Security Device Availability
 *Available
 Hidden
Embedded Security Activation Policy
 F1 to Boot
 Allow user to reject
 *No prompts

Windows Optimierung

Mit nachfolgendem Command Line kann die Windows Optimierung forciert / manuell ausgeführt werden:

Cmd.exe /c start /wait Rundll32.exe advapi32.dll,ProcessIdleTasks

UAC für eine Datei ausklammern

Mit nachfolgendem Registry Key kann die UAC für eine bestimmte Datei ausgeklammert werden:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers]

"C:\\Program Files (x86)\\%TOOL%\\%TOOL%.exe"="VISTASETUP RUNASADMIN"

SCCM Report: Client Overview mit Filter

Nachfolgender SCCM Report ermöglicht das Filtern nach Eigenschaften (zb. Domain, OS, User) und zeigt eine Hardware Overview der Zielsystem an:

 declare @Loc_ComputerName nvarchar(2000)
 if(ISNULL(@ComputerName , N'')=N'')
    select @Loc_ComputerName = N''
 else
    select @Loc_ComputerName = N'%' + @ComputerName + N'%'
   
 select  distinct v_R_System_Valid.ResourceID, 
 v_R_System_Valid.Netbios_Name0 AS [Computer Name], 
 v_R_System_Valid.Resource_Domain_OR_Workgr0 AS [Domain/Workgroup], 
 v_Site.SiteName as [SMS Site Name], 
 v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.TopConsoleUser0 AS [Top Console User], 
 v_GS_OPERATING_SYSTEM.Caption0 AS [Operating System], 
 v_GS_OPERATING_SYSTEM.CSDVersion0 AS [Service Pack Level], 
 v_GS_SYSTEM_ENCLOSURE_UNIQUE.SerialNumber0 AS [Serial Number], 
 v_GS_SYSTEM_ENCLOSURE_UNIQUE.SMBIOSAssetTag0 AS [Asset Tag], 
 v_GS_COMPUTER_SYSTEM.Manufacturer0 AS [Manufacturer], 
 v_GS_COMPUTER_SYSTEM.Model0 AS [Model], 
 v_GS_X86_PC_MEMORY.TotalPhysicalMemory0 AS [Memory (KBytes)], 
 v_GS_PROCESSOR.MaxClockSpeed0 AS [Processor (GHz)], 
 (Select sum(Size0) from v_GS_LOGICAL_DISK inner join v_FullCollectionMembership on (v_FullCollectionMembership.ResourceID = v_GS_LOGICAL_DISK.ResourceID ) 
 where v_GS_LOGICAL_DISK.ResourceID =v_R_System_Valid.ResourceID and v_FullCollectionMembership.CollectionID = @CollectionID) As [Disk Space (MB)], 
 (Select sum(FreeSpace0) from v_GS_LOGICAL_DISK inner join v_FullCollectionMembership on (v_FullCollectionMembership.ResourceID = v_GS_LOGICAL_DISK.ResourceID ) 
 where v_GS_LOGICAL_DISK.ResourceID =v_R_System_Valid.ResourceID and v_FullCollectionMembership.CollectionID = @CollectionID) As [Free Disk Space (MB)] 
 from v_R_System_Valid 
 inner join v_GS_OPERATING_SYSTEM on (v_GS_OPERATING_SYSTEM.ResourceID = v_R_System_Valid.ResourceID) 
 left join v_GS_SYSTEM_ENCLOSURE_UNIQUE on (v_GS_SYSTEM_ENCLOSURE_UNIQUE.ResourceID = v_R_System_Valid.ResourceID) 
 left join v_GS_COMPUTER_SYSTEM on (v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System_Valid.ResourceID) 
 LEFT join v_GS_X86_PC_MEMORY on (v_GS_X86_PC_MEMORY.ResourceID = v_R_System_Valid.ResourceID) 
 LEFT join v_GS_PROCESSOR on (v_GS_PROCESSOR.ResourceID = v_R_System_Valid.ResourceID) 
 inner join v_FullCollectionMembership on (v_FullCollectionMembership.ResourceID = v_R_System_Valid.ResourceID) 
 left join v_Site on (v_FullCollectionMembership.SiteCode = v_Site.SiteCode) 
 LEFT join v_GS_LOGICAL_DISK on (v_GS_LOGICAL_DISK.ResourceID = v_R_System_Valid.ResourceID) and v_GS_LOGICAL_DISK.DeviceID0=SUBSTRING(v_GS_OPERATING_SYSTEM.WindowsDirectory0,1,2) 
 left join v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP on (v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.ResourceID = v_R_System_Valid.ResourceID) 
 Where v_FullCollectionMembership.CollectionID = @CollectionID 
 and (v_R_System_Valid.Netbios_Name0 like @Loc_ComputerName or @Loc_ComputerName='') 
 and (v_R_System_Valid.Resource_Domain_OR_Workgr0 = @Domain or @Domain='') 
 and (v_Site.SiteName = @SMSSiteName or @SMSSiteName='') 
 and (v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.TopConsoleUser0 = @TopUser or @TopUser = '') 
 and (v_GS_OPERATING_SYSTEM.Caption0 = @OperatingSystem or @OperatingSystem='') 
 and (v_GS_COMPUTER_SYSTEM.Manufacturer0 = @Manufacturer or @Manufacturer = '') 
 and (v_GS_COMPUTER_SYSTEM.Model0=@Model or @Model = '') 
 Order by v_R_System_Valid.Netbios_Name0

SCCM Report: Hostname / Manufactor / SerialNumber / Model

Nachfolgende Query ergibt einen Report mit Hostname / Manufactor / SerialNumber / Model:

select v_R_System.Name0, v_GS_PC_BIOS.Manufacturer0, v_GS_PC_BIOS.SerialNumber0,v_GS_COMPUTER_SYSTEM.Model0

FROM v_R_System JOIN v_GS_PC_BIOS on  v_R_System.ResourceID =  v_GS_PC_BIOS.ResourceID JOIN v_GS_COMPUTER_SYSTEM on v_R_System.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID