help with report - works in sql studio

Created: 01 Feb 2013 | Updated: 01 Feb 2013 | 1 comment

TeleFragger

This issue has been solved. See solution.

ok so I took this to help us with our migration. The team likes it but want it as a report. When I try and put it in, it says failed and to check the logs.

I am heading out the door but curious if there is a special trick when you do any report like this..

thanks!

-- ****************************************************************************************

Select [Agent Name], [Product Version], Count([Agent Name]) as Count

from [Inv_AeX_AC_Client_Agent]

Where [Agent Name] in('Altiris Agent','Altiris eXpress NS Client',

'Altiris Software Update Agent','Altiris Application Metering Agent','Altiris Base Task Handlers',

'Altiris Client Task Agent','Altiris Client Task Scheduling Agent','Altiris Inventory Agent',

'Inventory Rule Agent','Software Management Framework Agent','Software Delivery Results Pickup Agent',

'Software Management Solution Agent')

and it works..

I have not done any drill down reports yet.. so I would like to right click one of these and get the machine name...

example is one of mine has 1700 with agent version 1 and 1 has agent version 2 so I have one computer not up to date.. would like to right click it and show the computer...

educate me please..