'On Loan' Asset State

[Clagnuts]

Hi, I’m trying to add and track the usage of our loan equipment.

1. I stared by creating a new ‘Asset Group’ called ‘Loan Equipment’.
2. I then created a new ‘Asset Type’, called ‘Wireless Dongles’.
3. I created a new ‘Asset State’ called, ‘On Loan’.
4. I added a new asset ‘Wireless_Dongle4’ assigning the Asset Group, Type and added the User Relation ‘Borrowed By’ to the user that loaned the dongle.

All good so far, however when I change the Asset State to my newly create ‘On loan’ state, the Asset Type and Asset Group disappear from the drop down Assets window, (next to Dashboard & Reports). It seems the only way to get them to show is to leave them in an Active State.
Is there any way around this or future release planned to address this issue? Thanks.

[Clagnuts]

Thanks the report is now working.

also just worked out that the asset states only show, when they have assets assigned. please ignore my last question.

Thanks for the help.

[Hemoco · Accepted solution]

Please try the following report:

Select tblAssets.AssetName,
tblAssets.AssetID,
tsysAssetTypes.AssetTypeIcon10 As Icon,
tblAssets.IPAddress As [IP Address],
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tblAssets.Lastseen
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Where tsysAssetTypes.AssetTypename = 'Wireless Dongles'
Order By tblAssets.AssetName

[Clagnuts]

Thank you for the reports, unfortunately the second returns an error,
"error while getting report
Conversion failed when converting the varchar value 'Wireless Dongles' to data type int."

Is there a future release or updated planned to show other states under the Asset Status section, below Active & Non-Active ?

[Hemoco]

The problem that this pages are only showing active assets. We have made two report for you where you can see all asset of a specific group/type.

This report you can use to see all asset from a specific asset group;
Select Distinct tblAssets.AssetName,
tblAssets.AssetID,
tsysAssetTypes.AssetTypeIcon10 As Icon,
tblAssets.IPAddress As [IP Address],
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tblAssets.Lastseen
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssetGroups.AssetGroup = 'Loan Equipment'
Order By tblAssets.AssetName


This report you can use to see all asset from a specific asset type.
Select tblAssets.AssetName,
tblAssets.AssetID,
tsysAssetTypes.AssetTypeIcon10 As Icon,
tblAssets.IPAddress As [IP Address],
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tblAssets.Lastseen
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Where tblAssets.Assettype = 'Wireless Dongles'
Order By tblAssets.AssetName

To use the report above, do the following:
• Open the report builder under Reports/Create New Report.
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.