Video Screencast Help

Application Usage Report by Computer

Created: 04 Jun 2013 | 5 comments

Dear All,

I am altiris beginner, May I know how to write a SQL statment to show "Application Usage Report by Computer" ?

Here is download from aonther forum. May I show the Application Name on the report only ? Not show software patch ??

Please help. Thanks

SELECT DISTINCT
                      TOP (100) PERCENT dbo.Inv_AddRemoveProgram.DisplayName AS Application, dbo.Evt_Application_Start.[Policy Name],dbo.Inv_AddRemoveProgram.DisplayVersion AS ProductVersion,
                      dbo.vUser.Department, dbo.vUser.[Office Location], UPPER(dbo.Inv_AeX_AC_Identification.Name) AS PCName,
                      dbo.Inv_AeX_AC_Identification.[Last Logon User] AS UserID, dbo.vUser.[Display Name] AS UserName, COUNT(DISTINCT CONVERT(NVARCHAR(40),
                      dbo.Evt_Application_Start.[Start Date], 21) + dbo.Evt_Application_Start.PID + CAST(dbo.Evt_Application_Start._ResourceGuid AS NVARCHAR(40))) AS '# Uses'
FROM         dbo.Evt_Application_Start INNER JOIN
                      dbo.Inv_AeX_AC_Identification ON dbo.Evt_Application_Start._ResourceGuid = dbo.Inv_AeX_AC_Identification._ResourceGuid INNER JOIN
                      dbo.vUser ON dbo.Inv_AeX_AC_Identification.[Last Logon User] = dbo.vUser.Name INNER JOIN
                      dbo.Inv_AddRemoveProgram ON dbo.Evt_Application_Start._ResourceGuid = dbo.Inv_AddRemoveProgram._ResourceGuid
WHERE (dbo.Inv_AeX_AC_Identification.Name LIKE '%Computer%')

AND (dbo.Evt_Application_Start.[Start Date] BETWEEN '%Start Date%' AND '%End Date%')

GROUP BY dbo.Inv_AddRemoveProgram.DisplayName, dbo.Inv_AddRemoveProgram.DisplayVersion, dbo.vUser.Department, dbo.vUser.[Office Location],
                      dbo.Inv_AeX_AC_Identification.[Last Logon User], dbo.vUser.[Display Name], dbo.Inv_AeX_AC_Identification.Name,dbo.Evt_Application_Start.[Policy Name]
HAVING      (dbo.Inv_AddRemoveProgram.DisplayName LIKE N'%Application%') AND (dbo.Inv_AeX_AC_Identification.[Last Logon User] <> N'')
ORDER BY Application

Comments 5 CommentsJump to latest comment

SK's picture

Does our built-in Application Metering reports not provide the data you are looking for?

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

superkelvin's picture

Hi SK,

Is it different with "Usage of Policy" ? I want to get data from below, but I don't know where to find them.

ApplicationMetering2.jpgApplicationMetering.jpg

SK's picture

At the moment you are only gathering metering data for the 7-Zip x64 software component associated with the 7-Zip managed software product.

Running our Application Metering "Executable Usage" report will provide more details.

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

superkelvin's picture

Hi SK,

Thanks for your help. But may I know how can I get the numbers of PC installed those Softwares ??

SK's picture

That report has a drilldown which lists the PC's individual usage data for the selected application.

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.