
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-29-2015 11:29 AM
Hello,
I've created the following Report. But it's not showing manually created assets. Can anybody see the problem?
Select Top 1000000 tblAssets.AssetUnique,
tsysOS.OSname,
tsysOS.Image As icon,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssets.Username,
tblAssets.Description As Computerdescription,
tblAssetCustom.Custom1 As [IV-Nummer],
tblAssetCustom.Custom2 As [IV-Besitzer],
tblAssetCustom.Custom3 As [IV-Datum],
tblAssetCustom.Custom4 As [IV-Abteilung],
tblAssets.Firstseen,
tblAssets.Lastseen,
tblState.Statename,
tblAssets.AssetID
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblAssetCustom tblAssetCustom1 On tblAssets.AssetID =
tblAssetCustom1.AssetID And tblState.State = tblAssetCustom1.State
Order By tblAssets.AssetName
I've created the following Report. But it's not showing manually created assets. Can anybody see the problem?
Select Top 1000000 tblAssets.AssetUnique,
tsysOS.OSname,
tsysOS.Image As icon,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssets.Username,
tblAssets.Description As Computerdescription,
tblAssetCustom.Custom1 As [IV-Nummer],
tblAssetCustom.Custom2 As [IV-Besitzer],
tblAssetCustom.Custom3 As [IV-Datum],
tblAssetCustom.Custom4 As [IV-Abteilung],
tblAssets.Firstseen,
tblAssets.Lastseen,
tblState.Statename,
tblAssets.AssetID
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblAssetCustom tblAssetCustom1 On tblAssets.AssetID =
tblAssetCustom1.AssetID And tblState.State = tblAssetCustom1.State
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
‎06-30-2015 04:27 PM
You added tsysOS to your report. This table only has entries for Windows computers which successfully were scanned. If you would like to list all assets, you need to change the join between tblAssets and tsysOS to a Left Join (select all rows from tblAssets). In the modified report below we also removed a duplicate version of tblAssetCustom.
Select Top 1000000 tblAssets.AssetUnique,
tsysOS.OSname,
tsysOS.Image As icon,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssets.Username,
tblAssets.Description As Computerdescription,
tblAssetCustom.Custom1 As [IV-Nummer],
tblAssetCustom.Custom2 As [IV-Besitzer],
tblAssetCustom.Custom3 As [IV-Datum],
tblAssetCustom.Custom4 As [IV-Abteilung],
tblAssets.Firstseen,
tblAssets.Lastseen,
tblState.Statename,
tblAssets.AssetID
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblState On tblState.State = tblAssetCustom.State
Order By tblAssets.AssetName
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-30-2015 04:27 PM
You added tsysOS to your report. This table only has entries for Windows computers which successfully were scanned. If you would like to list all assets, you need to change the join between tblAssets and tsysOS to a Left Join (select all rows from tblAssets). In the modified report below we also removed a duplicate version of tblAssetCustom.
Select Top 1000000 tblAssets.AssetUnique,
tsysOS.OSname,
tsysOS.Image As icon,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssets.Username,
tblAssets.Description As Computerdescription,
tblAssetCustom.Custom1 As [IV-Nummer],
tblAssetCustom.Custom2 As [IV-Besitzer],
tblAssetCustom.Custom3 As [IV-Datum],
tblAssetCustom.Custom4 As [IV-Abteilung],
tblAssets.Firstseen,
tblAssets.Lastseen,
tblState.Statename,
tblAssets.AssetID
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblState On tblState.State = tblAssetCustom.State
Order By tblAssets.AssetName
