Simple query for metering data

select
 s.Full_Domain_Name0
, s.Name0
, ru.[TimeStamp]
, ru.CompanyName0
, ru.ExplorerFileName0
, ru.FileDescription0
, ru.FileVersion0
, ru.FolderPath0
, ru.LastUserName0
from v_GS_CCM_RECENTLY_USED_APPS ru inner join v_R_System s on s.ResourceID = ru.ResourceID
where ExplorerFileName0 = 'MSACCESS.EXE'

 select
 s.Full_Domain_Name0
, s.Name0
, ru.[TimeStamp]
, ru.CompanyName0
, ru.ExplorerFileName0
, ru.FileDescription0
, ru.FileVersion0
, ru.FolderPath0
, ru.LastUserName0
from v_GS_CCM_RECENTLY_USED_APPS ru inner join v_R_System s on s.ResourceID = ru.ResourceID
where ExplorerFileName0 = 'WINPROJ.EXE'

 select
 s.Full_Domain_Name0
, s.Name0
, ru.[TimeStamp]
, ru.CompanyName0
, ru.ExplorerFileName0
, ru.FileDescription0
, ru.FileVersion0
, ru.FolderPath0
, ru.LastUserName0
from v_GS_CCM_RECENTLY_USED_APPS ru inner join v_R_System s on s.ResourceID = ru.ResourceID
where ExplorerFileName0 = 'VISIO.EXE'
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s