Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
AlexRus227
Engaged Sweeper
Hello. It is possible to create a report for all PCs. When was the last time Word or Excel was launched?
1 REPLY 1
AlexRus227
Engaged Sweeper
EventID start office 300

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Info,
tblADusers.email,
tblADusers.Department,
tblADusers.Title
From tblAssets
Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Left Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Where tblAssetCustom.State = 1 And Exists(Select tblNtlog.AssetID,
tblNtlog.Eventcode From tblNtlog
Where tblNtlog.AssetID = tblAssets.AssetID And tblNtlog.Eventcode = '300'
And tblNtlog.TimeGenerated >= DateAdd(dd, -90, GetDate()))
Order By tblAssets.AssetName

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now