I certainly do this easily enough with my own "reporting" code (Meta-Extract
/ Meta-Update) ... It's easy to generate reports like:
Cluster
Server XYZ
OS
App
App
Server
OS
App
App
Owners
Ppl
Ppl
Pending changes
Chg
Chg
Tickets
Hpd
Hpd
. . .
It use the remedy API exclusively (though It can also issue SQL query's
through the API and process it's results).
Meta-Extract can create any type of CSV, text file (such as an email), or
Meta-Update can place records in a reporting form of some sort.
Cheers
Ben Chernys
Senior Software Architect
Software Tool House Inc.
Canada / Deutschland / Germany
Mobile: +49 (0162) 175 0956 GMT + 1
Email: mailto:[EMAIL PROTECTED]
Web: http://www.softwaretoolhouse.com
A free notepad for Diary fields:
http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm
An ARS integration, import, batch facility:
http://www.softwaretoolhouse.com/products/SthMupd
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton Grams
Sent: September 12, 2006 12:57 AM
To: [email protected]
Subject: Re: CMDB Reporting Question
Speculation on my part, but... (thinking out loud here)
Every item in the cmdb has an entry in BMC_Asset. BMC_Asset contains the
class type for that record. This should be the top level/group of your
report. i.e., you could see all the class types at that level.
You could then drill down into each of those class types and use a
sub-report to gather more detailed information for that class (the class
value would be the driver for which sub-report to use).
Repeat the above on how you slice the data class->[sub-class->...]
Problem with this model is that the remedy odbc driver is incapable of
executing subreports, afaik; so you would need to connect to the db
directly. You can use the views generated by remedy for each of the forms
to create the top-level report and sub-reports.
Axton Grams
Kevin Shaffer wrote:
> ARS 7.x
> CMDB 1.1, patch 3
> Oracle 10g
>
> I'm a newbie to the CMDB world, so this may be a dumb question ... We have
our CMDB populated with data from BMC Topology. I have been tasked to
create a report that shows all servers, desktops, laptops and then drill
down into each of them to find the details of the asset, i.e Patch, OS, Mem,
HD Space, Processor, Software, etc ... My question is the attributes we
want to see are in 15-20 different forms .. How are others getting this data
into a nice report for managament?
>
> We have evaluated these options:
>
> 1. Create a view in the database and do the joins directly in Oracle
> 2. Create joins of joins in the Remedy Admin tools 3. Create
> subreports inside of Crystal.
>
> Any lessons learned out there on the best approach. Also I am struggling
with what links these tables. i.e How are the records in BMC_Patch related
back to BMC_Asset. Any advice.
>
> TIA
>
> Kevin
>
> ______________________________________________________________________
> _________ UNSUBSCRIBE or access ARSlist Archives at
> http://www.wwrug.org
>
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
