Symantec Management Platform (SMP) Community

 View Only

SMP - Reports - Asset User Owners 

Jan 14, 2019 11:58 AM

SMP SMP

Reports

Asset User Owners

Settings | Notification Server | Resource and Data Class Settings | Resource Associations | CMDB Assocation Types | Resource Association Asset User Owners

​GUID ed35a8d1-bf60-4771-9dde-092c146c485a

Details

​From Type Asset
​To Type ​User

Settings |  Notification Server | Resource and Data Class Settings |  Resource Types | Asset Types | Generic Asset Types | Resource Asset

Settings | Notification Server | Resource and Data Class Settings | Resource Types | Organizational Types | user User

 

If you go to a Computer in

Home | Service and Asset Management | icnCustomViewManage Configuration Items

icnCustomViewCI Management | Computers and Peripherals | ComputerComputer

Scroll down to near the bottom there is a section for

Asset Owners

This allows you to edit which Owner you wish to have against the Asset.

This can either be

  • User
  • Department

If you then need this information in a Report you can use the following SQL.

DECLARE @UserGuid AS UniqueIdentifier = NULL

SELECT 
    a.[Guid] AS [AssetGuid]
    ,a.[Name] AS [AssetName]
    --,rt.[Name] AS [AssetType]
    ,u.[Guid] AS [UserGuid]
    ,u.Email AS [UserEmail]
FROM vRM_Asset_Item a
INNER JOIN ResourceAssociation ra 
    ON a.Guid = ra.ParentResourceGuid AND ra.ResourceAssociationTypeGuid = 'ed35a8d1-bf60-4771-9dde-092c146c485a'
INNER JOIN vUser u
    ON ra.ChildResourceGuid = u.Guid
--INNER JOIN ResourceType rt
--    ON rt.Guid = a.ResourceTypeGuid
WHERE 
(
    (@UserGuid IS NULL) 
    OR (@UserGuid IS NOT NULL AND u.Guid = @UserGuid)
)

 

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Related Entries and Links

No Related Resource entered.