HI to all,

I have to list workstations who have MS VISIO installed and i have to have a column which give the date of the  last execution of this application.

Here is the query i wrote.The problem is that result given by the column which return the date of the last execution of this application is not correct.

"select distinct SMS_R_System.Name, SMS_R_System.ADSiteName, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_COMPUTER_SYSTEM.Model, SMS_R_System.LastLogonUserName, SMS_R_System.OperatingSystemNameandVersion, SMS_G_System_ADD_REMOVE_PROGRAMS.TimeStamp from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName is not null and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%MIcrosoft VISIO%" order by SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName"

Can you please tell me how to return the date of the last execution of an application.Thanks in advance for your help.

Regards,

LeBalbo2014

Can someone help me please?It has become critival for me to solve this issue.

Thank you .

This is not the correct table to query for last use.

Use this table instead v_GS_CCM_RECENTLY_USED_APPS and the value you are after is lastusedtime0

And you need to ensure you have a software metering rule in place for Visio