I currently have a query that shows what updates are currently applicable:
select distinct SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_G_System_PATCHSTATE.Product, SMS_G_System_PATCHSTATE.Status, SMS_G_System_PATCHSTATE.QNumbers, SMS_G_System_PATCHSTATE.Title, SMS_G_System_PATCHSTATE.Type, SMS_R_System.SMSUniqueIdentifier 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" order by SMS_G_System_PATCHSTATE.Product
Post ITMU upgrade I believe that I need to edit this query, could someone please tell me what needs to be edited? Thanks.
select distinct SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_G_System_PATCHSTATE.Product, SMS_G_System_PATCHSTATE.Status, SMS_G_System_PATCHSTATE.QNumbers, SMS_G_System_PATCHSTATE.Title, SMS_G_System_PATCHSTATE.Type, SMS_R_System.SMSUniqueIdentifier 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" order by SMS_G_System_PATCHSTATE.Product
Post ITMU upgrade I believe that I need to edit this query, could someone please tell me what needs to be edited? Thanks.