Notification

Icon
Error

When was the last launch of the Office programs

Posted: Thursday, October 31, 2019 4:04:52 PM(UTC)
AlexRus227

AlexRus227

Member Original PosterPosts: 10
0
Like
Hello. It is possible to create a report for all PCs. When was the last time Word or Excel was launched?
AlexRus227
#1AlexRus227 Member Original PosterPosts: 10  
posted: 11/1/2019 8:59:34 AM(UTC)
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

Active Discussions

Lansweeper Software Missing Report
by  RC62N   Go to last post Go to first unread
Last post: 12/6/2019 6:09:28 PM(UTC)
Lansweeper Assets without Asset Location
by  JLangthaler  
Go to last post Go to first unread
Last post: 12/5/2019 12:44:19 PM(UTC)
Lansweeper Installed Memory report
by  lansend   Go to last post Go to first unread
Last post: 12/2/2019 8:15:53 PM(UTC)
Lansweeper Custom OID Report
by  bramassendorp  
Go to last post Go to first unread
Last post: 12/2/2019 4:42:48 PM(UTC)
Lansweeper Report thats showing Windows machines when AV is not like =
by  RC62N   Go to last post Go to first unread
Last post: 11/28/2019 5:56:51 PM(UTC)
Lansweeper dhcp addresses available
by  Cesco93   Go to last post Go to first unread
Last post: 11/28/2019 2:56:02 PM(UTC)
Lansweeper All Assets Report on all IP-addresses and MAC-addresses
by  Tommy75  
Go to last post Go to first unread
Last post: 11/27/2019 11:54:44 AM(UTC)