Anyone integrated SAP into Altiris

mickwearn · 03-17-2009, 01:50 AM

Hi,

We have learned that we should be able to integrate SAP in to the Altiris asset solution. our aim is... when the Asset manager updates the status in SAP to decommissioned, this will be imported into Altiris an affect that assets individual asset status. thus removing the need for the service centre to manually have to set the status

The SAP tables are hundredous.. and where not really sure which table we need.. actually making the connection look suite easy.. but just not sure what to connect to.

Any advice or ideas?

Thanks
Mick W.
Au.

kschroeder · 03-17-2009, 12:34 PM

Hi Mick,
I wasn't directly involved with our SAP integration with Asset (we're importing POs with serial numbers to generate the assets) but I think what we ultimately did was have an ABAP program that output a CSV file that we then imported with Connector, versus connecting to the database directly. This may in part have to do with our SAP security configuration, not sure.

Don't know how much (if any) that helped...but it is what it is.

mickwearn · 03-18-2009, 06:15 PM

Hey Thanks for that, this is so far proving to be a really easy option for us,

Although.. now we are starting to find that SAP doesn’t really have all the details we need.

What we are trying to do... and I’m just trying to find out if it is possible, (worry about the how later) is..

We want to import the room/location details into Altiris, and set an asset status based upon that.

so if a workstation is located in Store Room 1, then the asset status will chage to Store Room 1, or if the location is Disposed then the asset status will be Decommissioned.

Does any one even know if this is possible?

Thanks.
Mick.

simopimo · 10-08-2009, 05:36 AM

Use a CMDB rule to do that - it's designed to do that sort of thing. Have it run daily/weekly/monthly (whatever). You could even create a data class for it to lookup the value in another table to make your queries easier.