/build/static/layout/Breadcrumb_cap_w.png

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?


0 Comments   [ + ] Show comments

Answers (2)

Posted by: D.Bertolotti 2 years ago
White Belt
0

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.

Posted by: Hobbsy 2 years ago
Red Belt
0

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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ