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")