Asset Management Suite

 View Only

  • 1.  Computers with no owner?

    Posted Dec 15, 2011 12:36 PM

    Hi,

     

    I'm looking to report on all computers with no owner assigned.  I have a query which shows me ownership information, but it only shows those assets with at least a single owner:

     

     

    SELECT
    vc.Guid
    FROM
    vComputer vc
    JOIN vAssetUserOwner auo ON vc.Guid = auo._AssetGuid
    JOIN vUser u ON auo._UGuid = u.Guid
    WHERE
     
    In addition, there used to be a report in 6 for Assets with no owner, but I don't see it anymore.
     
    Anyone have anything in their back pocket?


  • 2.  RE: Computers with no owner?

    Posted Dec 15, 2011 05:12 PM

    Amazing! I was just about to post the same request after our Asset guru said that a similar query would not work for him.

    Anyone?



  • 3.  RE: Computers with no owner?
    Best Answer

    Posted Dec 26, 2011 06:56 AM

    try this:

     

    SELECT
    vc.Guid,
    vc.Name,
    u.name
    FROM
    vComputer vc
    LEFT JOIN vAssetUserOwner auo ON vc.Guid = auo._AssetGuid
    LEFT JOIN vUser u ON auo._UGuid = u.Guid
    WHERE
    u.name is null


  • 4.  RE: Computers with no owner?

    Posted Dec 27, 2011 02:29 PM

    Thank-you --that query appears to do exactly what we need!



  • 5.  RE: Computers with no owner?

    Posted Jan 03, 2012 10:11 PM

    remember to do a exclusion on u.name like '%admin%' - in this case I assign the computers to the location owner. Happens a lot in testing departments

     

    never a good thing to make admin the owner of your computers. - go ahead ask me what its like to do a rerun of a months lease billing because this step was forgoten

     



  • 6.  RE: Computers with no owner?

    Posted Jan 25, 2012 08:43 AM

    Works like a charm.  I appreciate it.



  • 7.  RE: Computers with no owner?

    Posted Jan 26, 2012 03:15 AM

    Glad I could help