Video Screencast Help

help with report - works in sql studio

Created: 01 Feb 2013 • Updated: 01 Feb 2013 | 1 comment
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.. devil

Comments 1 CommentJump to latest comment

TeleFragger's picture

ok so sorry but I got the report working.. just need to do the drill down part...

agents.jpg

Did we help you? Please Mark As Solution those posts which resolve your problem,

SOLUTION