Asset Management Suite

 View Only

  • 1.  Automatically set 'In Stock' to 'Active'

    Posted May 10, 2011 03:23 PM

    Hello,

    So i did some digging and found this article:

    https://www-secure.symantec.com/connect/articles/automatically-set-status-back-active

    I would like to do the same for 'In Stock' to 'Active' once a machine from the "Stock Room" hit's the NS. Is this just a matter of switching out the Computer Asset GUID? If so how would i do this?

    thanks!



  • 2.  RE: Automatically set 'In Stock' to 'Active'

    Posted May 16, 2011 09:24 AM

    Now that i have put this task into place, it doesn't seem to be working. I manually set a computer to retired, then logged onto the machine and let it sit for a couple hours. The Status is still Retired. The task is enabled and set to every half hour..,Any thoughts?

     

    thanks.



  • 3.  RE: Automatically set 'In Stock' to 'Active'

    Posted Jun 03, 2011 03:16 AM

    Try to change the sql query a bit:

     

    declare @inStock uniqueidentifier
    set @inStock = '1C139F6C-F210-4002-90D0-4DFAF98D5FA4'
    declare @assetStatus uniqueidentifier
    set @assetStatus = '3028166F-C0D6-41D8-9CB7-F64852E0FD01'
    declare @hoursAfterLogon int
    set @hoursAfterLogon = 5 -- five hours after logged on
    select distinct
    _ResourceGuid AS GUID  
    from
    Evt_AeX_Client_LogOn ac
    join ResourceAssociation ra on ac._ResourceGuid = ra.ParentResourceGuid
    where
    ra.ResourceAssociationTypeGuid = @assetStatus and ra.ChildResourceGuid = @inStock
    and datediff(hh, ac._eventTime, getdate()) < @hoursAfterLogon


  • 4.  RE: Automatically set 'In Stock' to 'Active'

    Posted Jun 10, 2011 04:32 PM

    quick question.  How does one determine the guids for these statuses.  Im trying to do something similar both in 6.5 and 7.1