Jump to content


Established Members
  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About karthikj

  • Rank
  1. 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.
  • Create New...