Asset Management Group

 View Only

  • 1.  Creating Reports using Asset Management 7.5

    Posted Jan 20, 2015 02:54 PM

    Hello,

    I am trying to create a report with the following criteria - in Asset Management 7.5:

    • Owner (Perhaps - Primary User)
    • Name
    • Location
    • Cost Center
    • System Number
    • Serial Number

    I am very new to using this product/tool and would appreciate any assistance.

    Thanks,

    Greenhorn



  • 2.  RE: Creating Reports using Asset Management 7.5

    Posted Jan 20, 2015 04:01 PM

    Hello Greenhorn,

    On the SMP Console, from menu go to Reports > All Reports

    Right-click and create New > Folder and name it "My Reports"

    In that folder, right-click in the tree and select New > Report > Computer Report

    In the report editing view, enter report name and description

    Now go to Data Source > Fields.

    Click +Add to add more attributes

    To add all fields you need, enable Select Multiple Fields option and via Add button, add all relevant ones.

    There are additional formatting options, but for simple report - that was all you need.

    Save changes to generate report using these parameters.

     



  • 3.  RE: Creating Reports using Asset Management 7.5

    Posted Jan 21, 2015 03:02 PM

    I believe the query bellow can help you. Sorry for miss indentation but I'm working in Notpad.

    select ru.Name [Owner], vr.Name [Asset], va.[Asset Type], i1.Name [Location], rc.Name [Cost Center], va.[System Number], va.[Serial Number]  
    from vResourceEx vr JOIN
    vAsset va ON va._ResourceGuid = vr.Guid LEFT JOIN
    ResourceAssociation ra ON ra.ParentResourceGuid = vr.Guid
    AND ra.ResourceAssociationTypeGuid = 'ED35A8D1-BF60-4771-9DDE-092C146C485A' LEFT JOIN -- Asset User Owners    
    RM_ResourceUser ru ON ru.Guid = ra.ChildResourceGuid LEFT JOIN -- Get User Name
    ResourceAssociation ra1 ON ra1.ParentResourceGuid = vr.Guid
    AND ra1.ResourceAssociationTypeGuid = '05DE450F-39EA-4AAE-8C5F-77817889C27C' LEFT JOIN -- Asset Location
    Item i1 ON i1.Guid = ra1.ChildResourceGuid LEFT JOIN -- Get Location Name
    ResourceAssociation ra2 ON ra2.ParentResourceGuid = vr.Guid 
    AND ra.ResourceAssociationTypeGuid = '9BC22D17-C0CF-45D5-9A8F-D62BBAFD955D' LEFT JOIN -- Asset Cost Center 
    RM_ResourceCost_Center rc ON rc.Guid = ra2.ChildResourceGuid

    Order by vr.Name