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.
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
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.
Share this post
Link to post
Share on other sites