Client Management Suite

 View Only
  • 1.  NS 7 reporting

    Posted Apr 01, 2011 11:34 AM

    I am attempting to build a report that lists the owner of a PC.

    When I assign an owner in NS 7 I right click on the PC, I go to CMDB functions as specified in CMDB functions > Assignment Functions > Assign Owner

    I am unable to find a criteria that reports this data when building a report.

    I believe I have tried everything that contains 'owner' to no avail.

    Thanks!



  • 2.  RE: NS 7 reporting

    Posted Apr 01, 2011 01:00 PM

    SELECT vc.Name, uo.[User Name], uo.[Ownership Percentage] from vAssetUserOwner uo

    JOIN vComputer vc ON vc.Guid=uo._AssetGuid

    Does that work?  Otherwise the data class is [Ownership Details] and the columns are [Owner] and [Ownership Percentage].  By making it direct SQL you can leverage the vAssetUserOwner view which gives you [User Name] instead of just the GUID that [Owner] provides within resource manager.