cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
sharon2708
Engaged Sweeper
I'm trying to create this report I found in the forum - but I believe it is for an earlier version of Lansweeper - I need the version for lansweeper 5.0

Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, Web40OSName.OSname As OS, Web40OSName.SP, Web40OSName.OScode As Code, TsysLastscan.Lasttime As [Last Scan For Updates] From tblComputers Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join TsysLastscan On tblComputers.Computername = TsysLastscan.Computername Inner Join TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode Where tblComputers.Computername Not In (Select tblQuickFixEngineering.Computername From tblQuickFixEngineering Where tblQuickFixEngineering.Lastchanged > GetDate() - 30) And TsysWaittime.CFGname = 'quickfix' And tblComputers.Lastseen <> '' Order By tblComputers.ComputerUnique

I replaced Web40OSName with upgrade_Web40OSName and tblComputers with tblAssets but I still can't get the report working

Thanks
1 REPLY 1
Hemoco
Lansweeper Alumni
Something like this?

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon16 As icon,
tblOperatingsystem.Caption As OS,
tblOperatingsystem.ServicePackMajorVersion As SP,
tblQuickFixEngineering.InstalledOn,
tblQuickFixEngineering.Lastchanged,
tblQuickFixEngineeringUni.Description,
tblQuickFixEngineeringUni.FixComments,
tblQuickFixEngineeringUni.HotFixID,
tblQuickFixEngineeringUni.ServicePackInEffect,
TsysLastscan.Lasttime As [Last Scan For Updates]
From tblAssets
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblQuickFixEngineering On tblAssets.AssetID =
tblQuickFixEngineering.AssetID
Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineeringUni.QFEID =
tblQuickFixEngineering.QFEID
Inner Join TsysLastscan On tblAssets.AssetID = TsysLastscan.AssetID
Inner Join TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode
Where tblQuickFixEngineering.Lastchanged > GetDate() - 30 And
TsysWaittime.CFGname = 'quickfix'
Order By tblAssets.AssetName,
tblQuickFixEngineeringUni.Description