I have this project where I have to import SCCM and SAP data into the CMDB. This is my first time handling any of these.
Integrator has some issues with CPU utilizations so I started building things in AIE.
So far I have SCCM integration built in AIE.
Basically they want 2 types of classes from SCCM.
Computer and Software.
I created new attributes in ComputerSystem for IP address, Video Card, etc.
So I'm taking various tables from SCCM and merging them into the ComputerSystem class using ResourceID to match up things.
However the customer wants last login user and last login date and Number of disks.
1. Is there a table in SCCM that gives just that info? The one that I've been using is GS_SYSTEM_CONSOLE_USER but that gives me everyone that logged in. I just need the last one. And the number of disks. Is there a table in SCCM that just shows the number? Not a list of connected disks?
2. If not, can AIE have a rule / query to get that?
1. What's the table I should use to pull that info? I'm using GS_PRODUCTSOFTWARE but there are hundreds of entries for each computer.
2. Should I be filtering out some of the minor programs? Java, etc? If so, is that possible in AIE or normally done in the reconciliation or normalizing stage?
Next is the bigger challenge.
SAP. All the computer/server/printer/monitor data is in one table.
There is no easy identifier for these product types. There is a product name that kind of matches up to the product catalog.
The customer was told that Integrator can use the Product Name and then import into the proper classes all on its own.
1. Is that true? Can Integrator take 1 source and intelligently sort and push into the proper CI Class based on the Product Name (matching up to Product Catalog)?
If not, what other method is there to identify the class and push to the proper classes (like a filter)?
Is there a way in Integrator to do a lookup on the Product Catalog table and match it up to the SAP data?
What step would I use in Integrator?
Input > Table Source (Remedy) > Transform > Value Mapper?
Or would it be better to get the customer to just enter a product type into SAP?
Sorry for all the questions. Kind of stressed.
Thanks for the help.