Hi guys
We have a query that should detail machines that are pending a restart. However when the query is run the output isnt accurate, by which is shows machines that do not require a restart along with ones that do
Can anyone notice any glaring errors in the below query?
Thanks in advance
Richard
SELECT DISTINCT
sms_r_system.Name0 AS Hostname, dbo.System_DATA.SystemRole0 AS Type, sms_r_system.User_Name0 AS Username,
dbo.v_RA_System_SMSAssignedSites.SMS_Assigned_Sites0 AS Site, sms_r_system.AD_Site_Name0 AS [AD Site], sms_r_system.Client0 AS Client,
sms_r_system.Last_Logon_Timestamp0 AS [Last Logon], sms_r_system.Obsolete0 AS Obsolete,
sms_r_system.Operating_System_Name_and0 AS [OS Version]
FROM dbo.vSMS_R_System AS sms_r_system INNER JOIN
dbo.vSMS_Update_ComplianceStatus AS SMS_UpdateComplianceStatus ON SMS_UpdateComplianceStatus.MachineID = sms_r_system.ItemKey INNER JOIN
dbo.v_RA_System_SMSAssignedSites ON sms_r_system.ItemKey = dbo.v_RA_System_SMSAssignedSites.ResourceID INNER JOIN
dbo.System_DATA ON sms_r_system.ItemKey = dbo.System_DATA.MachineID
WHERE
(SMS_UpdateComplianceStatus.LastEnforcementMessageID = 9) AND
(dbo.System_DATA.SystemRole0 = @Type OR @Type IS NULL) AND
(dbo.v_RA_System_SMSAssignedSites.SMS_Assigned_Sites0 = @Site OR @Site = '[All]') AND
(AD_Site_Name0 = @ADSite OR @ADSite = '[All]')
ORDER BY Site, Hostname