→ 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: 
simonschon
Engaged Sweeper
Hi
I have searched alot for a report which contains the Manufactor/First-Lastname/Office/Operatingsystem ( Win10 or Win7)

Anyone have a nice report for sharing?
3 REPLIES 3
Esben_D
Lansweeper Employee
Lansweeper Employee
RCorbeil
Honored Sweeper II
Given the inclusion of first and last names in the request, office probably refers to tblADUsers.Office.
SELECT Top 1000000
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Office,

-- short form of OS name
tsysOS.OSname,

-- alternatively, more details
tblOperatingsystem.Caption,
tblOperatingsystem.ServicePackMajorVersion,
tblOperatingsystem.ServicePackMinorVersion,
tblOperatingsystem.Version
FROM
tblAssets
INNER JOIN tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
INNER JOIN tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
LEFT JOIN tblADusers On tblAssets.Username = tblADusers.Username And tblAssets.Userdomain = tblADusers.Userdomain
INNER JOIN tblOperatingsystem On tblAssets.AssetID = tblOperatingsystem.AssetID
INNER JOIN tsysOS On tblAssets.OScode = tsysOS.OScode
WHERE
tblAssetCustom.State = 1

I don't have any Win10 in my inventory yet, so I can't speak to how that shows up. If the short name is all you need, remove tblOperatingsystem from the report. If you want the extra detail, drop tsysOS.
Esben_D
Lansweeper Employee
Lansweeper Employee
Just to understand what fields you exactly want, what do you mean by Office? Could you please specify it?

To get you started you can always go through the built-in reports and edit them or use parts from them to create your reports.