Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-20-2014 07:35 PM
Hi,
I have this report but I want to add assettype, firstname of user, last name of user after AssetID. Can you assist? Also, is there field that I can add which version of MS Office it's running? If so, can you add it after OSname? Below is report that I have now.
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As Icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Model,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblAssets.Username,
tblAssetCustom.Serialnumber,
tsysIPLocations.IPLocation,
tblAssetCustom.Warrantydate
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Order By tblAssets.AssetName
I have this report but I want to add assettype, firstname of user, last name of user after AssetID. Can you assist? Also, is there field that I can add which version of MS Office it's running? If so, can you add it after OSname? Below is report that I have now.
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As Icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Model,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblAssets.Username,
tblAssetCustom.Serialnumber,
tsysIPLocations.IPLocation,
tblAssetCustom.Warrantydate
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Order By tblAssets.AssetName
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-21-2014 03:05 PM
Please use the report below:
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As Icon,
tblAssets.AssetID,
tblADusers.Firstname,
tblADusers.Lastname,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssetCustom.Model,
tblAssets.Domain,
tsysOS.OSname,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblAssets.Description,
tblAssets.Username,
tblAssetCustom.Serialnumber,
tsysIPLocations.IPLocation,
tblAssetCustom.Warrantydate
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Microsoft Office%'
Order By tblAssets.AssetName
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-21-2014 03:05 PM
Please use the report below:
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As Icon,
tblAssets.AssetID,
tblADusers.Firstname,
tblADusers.Lastname,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssetCustom.Model,
tblAssets.Domain,
tsysOS.OSname,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblAssets.Description,
tblAssets.Username,
tblAssetCustom.Serialnumber,
tsysIPLocations.IPLocation,
tblAssetCustom.Warrantydate
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Microsoft Office%'
Order By tblAssets.AssetName