Looking for tips or suggestions on how to best get server owner information out of my CMDB (SCSM) and onto a dashboard in Squared up. This would be a huge help if I could pull a lot of my custom fields over such as Primary contact, owning team and which patch window the server is in. Looking and trying to figure out best way to do this. Any tips or tutorials would be very helpful. I keep watching the masterclass video and it is currently pushing the limits of my current level of knowledge I know I will grasp all the concepts in there soon and be ready to move on to the next hurdle in delivering better dashboard out to my users.
I have no experience With SCSM on this Level, but i am surprised the two Products dosen’t integrate better than this out of the Box.
I can try and guide you in the right direction as i have done the same thin With data from Our CMDB.I suggest you extend the Windows Computer class With your additional Properties (Customer, service Level +++). You can populate the data With a PowerShell script or you can create a custom discovery that runs on the management server(s) to do the same.
I ended up creating a New management pack With a discovery targeting the management servers which grabs all the data from a web based CMDB With a rest API endpoint.
The Squared Up team will be issuing some guidance and product updates in the next few weeks to demonstrate how you can integrate with SCSM and other CMDBs. Watch this space.
My first thought was to create a perspective for windows computers and then pull in the server name from my cmdb database and display the relevant views not sure if a database view would work best or a script. I already have all the data in the cmdb just need to pull it into a dashboard view.
Perhaps use of the SQL tile would suit your needs?
I was thinking the same thing. I am sure its just my learning curve hitting me again but how would I have the query dynamically update with the name of the server being viewed?