1 of 1 people found this helpful
Login to Application menu > Smart Reporting > Smart Reporting Console
From the top menu, Create > View
Select AR System as the data source
Select Multiple Tables radio button
Click Create View
On the left, Database Tables box, search AST:BaseElement and drag to the Entity Relationships work area
Do the same but for SIT:Site
Click Create New Join button
Select Inner join (so you only want the ones that match) as the Join Type
Select Many to one e.g. many Assets to one Site as the Cardinality
Build the join details as Building Equal to Site Click Add and Save & Close
Click the Gear icon on the AST:BaseElement and select the columns you need on the right. Example below:
Below the list of Columns, click Conditions: AST:BaseElement
Click New and add two sets. First Data Set Id to BMC.ASSET to make sure you only get production data
Then one NOT IN LIST to make sure you exclude unwanted data such as people or service requests. Have a play. Example here:
Click the Gear icon on the SIT:Site and select the columns you need on the right, assume you want Zip/Postal Code.
Click Prepare from the top menu and check some of the data
Click View > Save. Name the view. Click Save and Publish
Now you can create a report from the Create > Report and select your new view.
Hope this helps
SSO Plugin - Easy to implement and manage Single Sign On (SSO) for BMC
My own personal BMC Remedy thoughts
Many thanks for the step by step explanation, very helpful.
I managed to create my report in the end.