Um immer einen Überblick zu haben, sollten gewisse Abfragen einfach in jede Sammlung gehören. Anzeigen lassen aller Laptops:
- select SMS_R_System.NetbiosName, SMS_R_System.ADSiteName, SMS_R_System.IPAddresses, SMS_G_System_COMPUTER_SYSTEM.InstallDate from
- SMS_R_System
- inner join SMS_G_System_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId
- 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")