Forgive me for filling this site with "Newb" questions but i've not been trained on altiris and we are not using the full fat asset managment etc and use GP to push apps (will be moving to Altiris to deply next year) so Altiris is just monitoring EXE's and i'm having to use fields like "Known As" and "prodcut name" to report on programs at the moment.
I have edited this coding to report on software usage. I have managed to get this working using Dropdown box that the end user (It Procurement) see the application name but it's actually reporting on the EXE. for example they want to report on "Visio" so i have the report look for "Visio.exe" etc.
The report is working! i get the usage report out and it groups the installs together into a block of "versions" (near enough) but it would be nice to have a colomn that tell me how many "instances" of that application are installed.
So i can see that there are 700 Visio installs that combined have run 4500 in a month .. is there a way to also mack this "clickable" so that you can open the item up and it will then list the individual PC's in that group with the primary username? this would be rather cool and god like.
Thanks!
BEGIN
SELECT DISTINCT Manufacturer, [Product Name],
CASE LEFT(amms.[Product Version], 3)
WHEN '7.' THEN '7'
WHEN '8.' THEN '8'
WHEN '9.' THEN '9'
WHEN '10.' THEN '10'
WHEN '11.' THEN '11'
WHEN '12.' THEN '12'
WHEN '13.' THEN '13'
WHEN '14.' THEN '14'
WHEN '15.' THEN '15'
WHEN '(u' THEN 'U'
ELSE amms.[Product Version]
END AS [Version], amms.[File Name] AS [File Name], Pname.[Month] AS [Month],
SUM([Run Count]) AS [# of Uses]
-------- Reporting Object data set and variable ------------
FROM Inv_AeX_AM_Monthly_Summary_Archive amms
JOIN Inv_AeX_AC_Primary_User Pname
ON amms._resourceGuid = PName._ResourceGuid
-------- Combo Box/ user prompt Variable --------
WHERE Pname.[Month] LIKE '%' + '%Month%' + '%'
And amms.[File Name] LIKE '%' + '%_AppName%' + '%'
--------This is the Output Information-----------
GROUP BY Manufacturer,amms.[Product Name], amms.[Product Version], amms.[File Name], Pname.[Month]
ORDER BY [# of Uses] DESC
END