Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-09-2017 08:47 AM
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?
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?
Labels:
- Labels:
-
Report Center
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-10-2017 03:50 PM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-09-2017 07:37 PM
Given the inclusion of first and last names in the request, office probably refers to tblADUsers.Office.
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.
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-09-2017 11:56 AM
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.
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.