Changing Device Status of an Archived Device
We have a number of devices listed as Archived and now we need to change their status to dispoded and enter a disposal date but have not been able to find a way to do that. Any suggestions?
Answers (2)
Your suggestion is a bit beyond my area of expertise but another staff memeber of ours is able t ohelp wit hthis so I think we should be OK going forward. He had no need previously to record this data but that has since changed so we found ourselves needing to back fill a number of entries but going forard will be able to enter the necessary data as assets are being retired and swapped out for new.
You cannot change the status of an archived Asset from the web UI, as it will maintain the Status that it had, when it was archived, however.....
If you create a ticket rule you will be able to update the Asset table directly and update the status as you need to.
To do this create an SQL ticket rule, use the following text in your Select statement:
SELECT
ASSET.ID,
ASSET.ASSET_STATUS_ID,
ASSET.ARCHIVE
FROM ASSET ASSET
WHERE (ASSET.ID = 19)
AND (ASSET.ASSET_STATUS_ID = 493)
AND (ASSET.ARCHIVE = 'COMPLETED')
You can add in the Asset Id of the archived asset which you wish to change (ASSET.ID = 19) but you will also need to find out the Asset status ID that the asset is currently set to, in its archived state (highlighted in blue above)
To find the Asset Status ID is pretty simple, just create an SQL report and put into it
SELECT * FROM ASSET_STATUS
That will give you a complete dump of the Asset status table
Once you have the correct Status and Asset ID in your select statement, use the following SQL in your update statement
UPDATE ASSET
SET
ASSET.ASSET_STATUS_ID = "494"
where
(ASSET.ID in (<TICKET_IDS>))
Where the Asset Status ID is above (494), needs to be the status you want the archived asset to permanently have.
Run the rule and the Archived asset status should be updated.
If you want to expand this code out update multiple assets, you can do that by adding to the WHERE statement in the SELECT Statement.
Be aware the ASSET_STATUS.ARCHIVE_DATE holds the date that the asset was Archived and
ASSET_STATUS.ARCHIVE will contain "COMPLETED" if the asset is archived.
If you would like any more help with regards to managing your assets in KACE, then please feel free to reach out to me directly