You should be careful of using the last login user. While this may work for most CIs, there could be ones that are shared machines and the Last Login would not be accurate. There is an field in SCCM called TopConsoleuser0 that can be used instead from an SCCM table called v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP. That is the person that uses the asset more than 60% of the time in a 90 day period. You could use AI to put this together because you will need to have the a few fields from the People form, like login and entry ID, and the Instance ID and Asset ID from the BMC_BaseElement in order to fill out the AST:Asset People form.
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kevin Shaffer Sent: Wednesday, November 19, 2014 4:40 PM To: arslist@ARSLIST.ORG Subject: Creating Asset People Relationships Using AI ** ARS 8.1 We are populating the CMDB using Spoon jobs to integrate SCCM and Remedy. I am trying to create a people relationship to the CI using the Last Logged On value from SCCM. The previous developer actually passes the Login Name from SCCM to the Owner Name field on the Computer System class. I am trying to decide if it is just best to create Filters to take that value and create a record in the AST:Asset People form or if there is a better approach with Spoon or should I create a Staging form to create the relationship or are companies managing this data with periodic updates using the DMT (Data Management Tool). I am not looking at suggestions with 3rd party products. I am expecting that this is a common requirement at other customer sites and was wondering how they have accomplished this requirement. Any lessons learned would be appreciated. Thanks Kevin _ARSlist: "Where the Answers Are" and have been for 20 years_ Information contained in this email is subject to the disclaimer found by clicking on the following link: http://www.lyondellbasell.com/Footer/Disclaimer/ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"