Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SMS Web Report
- Thread starter joech
- Start date
Heres a start... for 2003 with 2.0 you need to modify the sms_def.mof
select SMS_R_System.NetbiosName, SMS_G_System_PATCHSTATE.Product, SMS_G_System_PATCHSTATE.QNumbers from SMS_R_System inner join SMS_G_System_PATCHSTATE on SMS_G_System_PATCHSTATE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_PATCHSTATE.Status = "Applicable"
select SMS_R_System.NetbiosName, SMS_G_System_PATCHSTATE.Product, SMS_G_System_PATCHSTATE.QNumbers from SMS_R_System inner join SMS_G_System_PATCHSTATE on SMS_G_System_PATCHSTATE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_PATCHSTATE.Status = "Applicable"
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question