Hi friends,
i am looking for a report in sccm 2007 which should give me the old definitions of the servers only , currently iam getting the report including the workstations as well .Please find the sql query used
select a.Name0 as "Computer Name",B.Client_Version00 as "Client Version", B.Engine_Version00 as "Engine Version",B.Antivirus_Version00 as "Antivirus Version", B.AntiSpyware_Version00 as "AntiSpyware Version",B.Antivirus_Update_Date00 as "Last Updated Date" from V_R_System A join MS_Forefront_Data B on A.ResourceID=B.machineID order by a.Name0
Request your help in fixing this issue at the earliest.