LANSWEEPER LAST LOGON REPORT CODE
LANSWEEPER LAST LOGON REPORT PC

Left Join dbo.tblAssetCustom ASCUST On ASSETS.AssetID = ASCUST.AssetID Left Join dbo.tblADComputers COMP on ASSETS.AssetID = COMP.AssetID ,ASOP.ServicePackMajorVersion as OperatingSystemServicePack Select top 100 percent AssetInfo.AssetName Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID Join tsysOS On tblAssets.OScode = tsysOS.OScode Left Outer Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID

Select Top 1000000 tblAssets.Username As Username,

LANSWEEPER LAST LOGON REPORT PC

I would like the report to show the last pc a user signed into along with the info above. My report shows a list of assets with the last user that signed in.

LANSWEEPER LAST LOGON REPORT CODE

Here is the code that I made to gather the info I need. I would like to link the tables that provide the following information. I like the Basic report above, but I am having trouble adding other tables. Guys I used it and it's awesome! thanks so much!īy the way: why do I still see some users that have been disabled in my AD and moved to the disabled users OU? You should link to tblAssets the same way as in your current report. Where tblDiskdrives.Caption = 'c:' And tblAssetCustom.State = 1Īnd tblADUsers.OU Not Like '%Disabled Users%' Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID Inner Join tblAssets On tblAssets.AssetID = tblCPlogoninfo.AssetID Left Join tblADUsers ON tblADUsers.Userdomain = SubQuery.Domain AND tblADUsers.Username = SubQuery.Username TblCPlogoninfo.logontime = SubQuery.LastLogon SubQuery.Username And tblCPlogoninfo.Domain = SubQuery.Domain And

TblCPlogoninfo.Domain) SubQuery On tblCPlogoninfo.Username = Max(tblCPlogoninfo.logontime) As LastLogon Inner Join (Select Top 1000000 tblCPlogoninfo.Username, Round((Cast((DateDiff(mm, tblBIOS.ReleaseDate, GetDate())) As float) / 12),Ĭast(Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 AsĬast(Cast(Cast(tblAssets.Memory As bigint) / 1024 As numeric) As nvarchar) As You can change the label on line 37 as needed. I did tweak the original query to not include domain users in a disabled users OU. The report pulls from the logoninfo table which makes no distinction of active users.

Lansweeper last logon report