http://www.microsoft.com/en-us/windows/enterprise/products-and-technologies/windows-8-1/compare/default.aspx
Mittwoch, 18. September 2013
Dienstag, 17. September 2013
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%"
Mittwoch, 4. September 2013
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
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
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
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
Dienstag, 3. September 2013
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
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
Installation Treiber über CommandLine
mit nachfolgendem Command kann ein Treiber (ohne) Setup über Command Line installiert werden:
C:\Windows\System32\pnputil.exe -i -a .\*.inf
C:\Windows\System32\pnputil.exe -i -a .\*.inf
Powershell Restriction Policy in einem Befehl aufheben
Mit nachfolgendem Befehl kann die Powershell Restriction Policy für eine Command Line aufgehoben werden:
C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
-Command "if ((Get-ExecutionPolicy) -eq 'Restricted'){Set-ExecutionPolicy
Unrestricted -Scope Process -Force }; . 'c:\test\meinscript.ps1'"
Restart SCCM Tasksequence in Windows PE
Mit der Anwendung X:\sms\bin\x64\TsBootShell.exe kann eine Tasksequence im Windows PE Modus manuell gestartet werden.
SQL Query "Computer pro Model"
SQL Query "Computer pro Model"
SELECT Model0 , COUNT (Model0) AS Expr1 FROM v_GS_COMPUTER_SYSTEM Group by Model0 Order by Model0
SELECT Model0 , COUNT (Model0) AS Expr1 FROM v_GS_COMPUTER_SYSTEM Group by Model0 Order by Model0
Get Computer Model
Command:
WMIC ComputerSystem GET Model
Query:
SELECT * FROM Win32_ComputerSystem where Model like 'HP EliteBook 8570p%'
WMIC ComputerSystem GET Model
Query:
SELECT * FROM Win32_ComputerSystem where Model like 'HP EliteBook 8570p%'
Sonntag, 1. September 2013
Windows 8 Powerplans
Powerplan auf High Performance setzen:
powercfg setactive 8c5e7fda-e8bf-4a96-9a85-a6e23a8c635c
Powerplan auf Ausbalanciert setzen:
powercfg setactive 381b4222-f694-41f0-9685-ff5bb260df2e
powercfg setactive 8c5e7fda-e8bf-4a96-9a85-a6e23a8c635c
Powerplan auf Ausbalanciert setzen:
powercfg setactive 381b4222-f694-41f0-9685-ff5bb260df2e
Windows 8 Features über Command aktivieren
Features abrufen:
Dism /online /Get-Features
Beispiel .NET
bei Windows 8 (mit Sourceangabe):
dism /online /enable-feature /featurename:NetFx3 /All
/Source:D:\sources\sxs /LimitAccessBeispiel Telnet bei Windows 8 (ohne Sourceangabe):
dism /online /Enable-Feature /FeatureName:TelnetClient
TechNet:
http://technet.microsoft.com/en-us/library/hh824822.aspx
Featurelist Windows 8:
Microsoft-Hyper-V-AllMicrosoft-Hyper-V-Tools-All
Microsoft-Hyper-V
Microsoft-Hyper-V-Management-Clients
Microsoft-Hyper-V-Management-PowerShell
Printing-Foundation-Features
Printing-Foundation-LPRPortMonitor
Printing-Foundation-LPDPrintService
Printing-Foundation-InternetPrinting-Client
FaxServicesClientPackage
ScanManagementConsole
RemoteServerAdministrationTools
RemoteServerAdministrationTools-ServerManager
RemoteServerAdministrationTools-Roles
RemoteServerAdministrationTools-Roles-CertificateServices
RemoteServerAdministrationTools-Roles-CertificateServices-CA
RemoteServerAdministrationTools-Roles-CertificateServices-OnlineResponder
RemoteServerAdministrationTools-Roles-AD
RemoteServerAdministrationTools-Roles-AD-DS
RemoteServerAdministrationTools-Roles-AD-DS-SnapIns
RemoteServerAdministrationTools-Roles-AD-DS-AdministrativeCenter
RemoteServerAdministrationTools-Roles-AD-Powershell
RemoteServerAdministrationTools-Roles-DHCP
RemoteServerAdministrationTools-Roles-DNS
RemoteServerAdministrationTools-Roles-RemoteAccess
RemoteServerAdministrationTools-Roles-FileServices
RemoteServerAdministrationTools-Roles-FileServices-Dfs
RemoteServerAdministrationTools-Roles-FileServices-Fsrm
RemoteServerAdministrationTools-Roles-FileServices-Nfs
RemoteServerAdministrationTools-Roles-FileServices-StorageMgmt
RemoteServerAdministrationTools-Roles-RDS
RemoteServerAdministrationTools-Roles-RDS-Gateway
RemoteServerAdministrationTools-Roles-RDS-LicensingUI
RemoteServerAdministrationTools-Roles-RDS-LicensingDiagUI
RemoteServerAdministrationTools-Roles-VA
RemoteServerAdministrationTools-Roles-WSUS
RemoteServerAdministrationTools-Roles-WSUS-API
RemoteServerAdministrationTools-Roles-WSUS-UI
RemoteServerAdministrationTools-Features
RemoteServerAdministrationTools-Features-BitLocker
RemoteServerAdministrationTools-Features-Clustering
RemoteServerAdministrationTools-Features-GP
RemoteServerAdministrationTools-Features-IPAM
RemoteServerAdministrationTools-Features-LoadBalancing
RemoteServerAdministrationTools-Features-NICTeaming
RemoteServerAdministrationTools-Features-Wsrm
SimpleTCP
SNMP
WMISnmpProvider
Windows-Identity-Foundation
MicrosoftWindowsPowerShellV2Root
MicrosoftWindowsPowerShellV2
DirectoryServices-ADAM-Client
Internet-Explorer-Optional-amd64
NetFx3
IIS-WebServerRole
IIS-WebServer
IIS-CommonHttpFeatures
IIS-HttpErrors
IIS-HttpRedirect
IIS-ApplicationDevelopment
IIS-NetFxExtensibility
IIS-NetFxExtensibility45
IIS-HealthAndDiagnostics
IIS-HttpLogging
IIS-LoggingLibraries
IIS-RequestMonitor
IIS-HttpTracing
IIS-Security
IIS-URLAuthorization
IIS-RequestFiltering
IIS-IPSecurity
IIS-Performance
IIS-HttpCompressionDynamic
IIS-WebServerManagementTools
IIS-ManagementScriptingTools
IIS-IIS6ManagementCompatibility
IIS-Metabase
WAS-WindowsActivationService
WAS-ProcessModel
WAS-NetFxEnvironment
WAS-ConfigurationAPI
IIS-HostableWebCore
IIS-CertProvider
IIS-WindowsAuthentication
IIS-DigestAuthentication
IIS-ClientCertificateMappingAuthentication
IIS-IISCertificateMappingAuthentication
IIS-ODBCLogging
IIS-StaticContent
IIS-DefaultDocument
IIS-DirectoryBrowsing
IIS-WebDAV
IIS-WebSockets
IIS-ApplicationInit
IIS-ASPNET
IIS-ASPNET45
IIS-ASP
IIS-CGI
IIS-ISAPIExtensions
IIS-ISAPIFilter
IIS-ServerSideIncludes
IIS-CustomLogging
IIS-BasicAuthentication
IIS-HttpCompressionStatic
IIS-ManagementConsole
IIS-ManagementService
IIS-WMICompatibility
IIS-LegacyScripts
IIS-LegacySnapIn
IIS-FTPServer
IIS-FTPSvc
IIS-FTPExtensibility
MSMQ-Container
MSMQ-Server
MSMQ-Triggers
MSMQ-ADIntegration
MSMQ-HTTP
MSMQ-Multicast
MSMQ-DCOMProxy
WCF-Services45
WCF-HTTP-Activation45
WCF-TCP-Activation45
WCF-Pipe-Activation45
WCF-MSMQ-Activation45
WCF-TCP-PortSharing45
WCF-HTTP-Activation
WCF-NonHTTP-Activation
NetFx4-AdvSrvs
NetFx4Extended-ASPNET45
MediaPlayback
WindowsMediaPlayer
Microsoft-Windows-MobilePC-Client-Premium-Package-net
Microsoft-Windows-MobilePC-LocationProvider-INF
Printing-XPSServices-Features
RasCMAK
RasRip
MSRDC-Infrastructure
SearchEngine-Client-Package
TelnetClient
TelnetServer
TFTP
TIFFIFilter
Xps-Foundation-Xps-Viewer
Windows-Defender-Default-Definitions
ServicesForNFS-ClientOnly
ClientForNFS-Infrastructure
NFS-Administration
SUA
Windows 8 - unerwarteter Sleep Mode
Verhalten:
Windows 8 geht während des Betriebs unerwartet in den Standby.
Option Unattended Sleep Timeout hinzufügen:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Power\PowerSettings\238C9FA8-0AAD-41ED-83F4-97BE242C8F20\7bc4a2f9-d8fc-4469-b07b-33eb785aaca0]
"Attributes"=dword:00000002
Anschliessend werden die Energie Optionen durch untenstehende Einstellung erweitert:
Option Unattended Sleep Timeout entfernen:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Power\PowerSettings\238C9FA8-0AAD-41ED-83F4-97BE242C8F20\7bc4a2f9-d8fc-4469-b07b-33eb785aaca0]
"Attributes"=dword:00000001
Windows 8 geht während des Betriebs unerwartet in den Standby.
Option Unattended Sleep Timeout hinzufügen:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Power\PowerSettings\238C9FA8-0AAD-41ED-83F4-97BE242C8F20\7bc4a2f9-d8fc-4469-b07b-33eb785aaca0]
"Attributes"=dword:00000002
Anschliessend werden die Energie Optionen durch untenstehende Einstellung erweitert:
Option Unattended Sleep Timeout entfernen:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Power\PowerSettings\238C9FA8-0AAD-41ED-83F4-97BE242C8F20\7bc4a2f9-d8fc-4469-b07b-33eb785aaca0]
"Attributes"=dword:00000001
Abonnieren
Posts (Atom)