→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JarradW
Engaged Sweeper
Can someone please help clean up the current report I've put together from the forums?

https://www.lansweeper.com/forum/yaf_postst15168_Windows--Deployment-logs--Built-in.aspx#post51418
https://www.lansweeper.com/forum/yaf_postst13513_Reports-from-Deployment-Logs.aspx#post47765
https://www.lansweeper.com/forum/yaf_postst15977_Deployment-report-with-only-newest-entries.aspx#post53775

So far I've managed to include the following:
Computer Uptime
FortiClient under version 6.4*
Patch Status
Specific Asset Group

Would like to include:
Last successful deployment per asset and not a giant list of every packagename deployed against an asset..
RunMode i.e. System Account, Scanning Credentials, Currently Logged On

Any help would be appreciated as I've logged a support email to Support@lansweeper.com as well

Thanks

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Description,
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 /
24))) + ' days ' +
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 %
24))) + ' hours ' +
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) % 3600 /
60))) + ' minutes' As Uptime,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftware.Installdate,
Case
When tblSoftware.softwareVersion < '6.4*' Then 'Out of Date'
Else 'Up to Date'
End As [Patch Status],
tsysPackages.PackageName,
tsysPackages.Timeout,
tsysPackageLogs.Success,
tsysIPLocations.IPLocation,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
Case
When tblSoftware.softwareVersion < '6.4*' Then '#ffadad'
Else '#d4f4be'
End As backgroundcolor,
tsysAssetTypes.AssetTypeIcon10 As icon,
tsysPackages.PackageID
From tblAssets
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join lansweeperdb.dbo.tblSoftware On tblAssets.AssetID =
tblSoftware.AssetID
Inner Join lansweeperdb.dbo.tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Inner Join lansweeperdb.dbo.tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID,
lansweeperdb.dbo.tsysPackages,
lansweeperdb.dbo.tsysPackageLogs
Where tblSoftwareUni.softwareName Like '%FortiClient%' And
tsysPackages.PackageName = 'Upgrade FortiClient' And
tblAssetGroups.AssetGroup = 'Kew - Unit 1 - Computers'
Order By tblAssets.Description,
tblAssets.IPNumeric
0 REPLIES 0

New to Lansweeper?

Try Lansweeper For Free

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

Try Now