Details
Kategorie: SCCM

Um immer einen Überblick zu haben, sollten gewisse Abfragen einfach in jede Sammlung gehören. Anzeigen lassen aller Laptops:

View source
  1. select SMS_R_System.NetbiosName, SMS_R_System.ADSiteName, SMS_R_System.IPAddresses, SMS_G_System_COMPUTER_SYSTEM.InstallDate from 
  2. SMS_R_System 
  3. inner join SMS_G_System_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId 
  4. inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes in ("8","9","10","14","11")

Zugriffe: 803