Re: Searching for CIs with specific related records
Rick, For the specific example you quoted you could simply search on the operating system form. OS's are related to computers by weak relationships and, out of the box, the name of the parent propagates to weak child. The name of the computer is therefore available in the SystemName field of the OS CI. Cheers Peter From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mueller, Doug Sent: 27 August 2010 20:39 To: arslist@ARSLIST.ORG Subject: Re: Searching for CIs with specific related records ** Rick, Never satisfied Always something else you want. (which by the way is a good thing because it means you are looking for more things to be able to do more things) Not directly. There is an API call you can use to get the data. So, if you had the criteria and could pass it to something that could make the call, then return the data. But, I don't believe there is a way to just get the data from the CMDB result screen since that is not done in an AR System table. Doug _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Friday, August 27, 2010 12:23 PM To: arslist@ARSLIST.ORG Subject: Re: Searching for CIs with specific related records ** Thanks, Doug. I did find that function, and it works just as you described. If I may ask a followup, is it possible to take those final results and attach them to the RFC directly from the cross class search results? Rick _ From: Mueller, Doug doug_muel...@bmc.com Sender: Action Request System discussion list(ARSList) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Searching for CIs with specific related records
Rick, OK, it has been a few weeks. So, I am behind a little.. The operation you describe is a standard, supported operation within the CMDB. You can go to a CMDB screen directly and perform this search. You can request exactly what you want For class that holds OSes (OK, so I don't know the name) where value is Windows 2003 that is connected using a relationship of class y to the class that holds patches where the value of the patch is service pack 3 And to go further, it could be Computer systems that are connected to OSes using relationship z and the query from above to find the systems rather than the OS instances. No joins need to be created. No special preparation. You can do a multi-class search following relationships and get back a result of the system following the cross class qualification. Hopefully, you have found this by now. But, just in case not, I wanted to send a note (a less than timely but hopefully useful one). Doug From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, August 10, 2010 12:33 PM To: arslist@ARSLIST.ORG Subject: Searching for CIs with specific related records ** I have a requirement to be able to search for CIs with specific related records with a specific attribute value. For instance: I create an RFC to upgrade all Windows 2003 servers to Service Pack 3. To do that, I need to identify which Windows Servers have a 2003 OS that is at SP 2 or below. The problem is that in ITSM 7.5, the server and the OS are stored in separate CMDB tables. How would I go about setting up a query (apart from creating a DB join) that would help me locate only the CIs appropriate to the issue the RFC is addressing? This would ideally be from the Change Management application, though we could use the Asset Management application if it were the only way. Rick _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Searching for CIs with specific related records
Thanks, Doug. I did find that function, and it works just as you described. If I may ask a followup, is it possible to take those final results and attach them to the RFC directly from the cross class search results? Rick -Original Message- From: Mueller, Doug doug_muel...@bmc.com Sender: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG Date: Fri, 27 Aug 2010 14:16:54 To: arslist@ARSLIST.ORG Reply-To: arslist@ARSLIST.ORG Subject: Re: Searching for CIs with specific related records Rick, OK, it has been a few weeks. So, I am behind a little.. The operation you describe is a standard, supported operation within the CMDB. You can go to a CMDB screen directly and perform this search. You can request exactly what you want For class that holds OSes (OK, so I don't know the name) where value is Windows 2003 that is connected using a relationship of class y to the class that holds patches where the value of the patch is service pack 3 And to go further, it could be Computer systems that are connected to OSes using relationship z and the query from above to find the systems rather than the OS instances. No joins need to be created. No special preparation. You can do a multi-class search following relationships and get back a result of the system following the cross class qualification. Hopefully, you have found this by now. But, just in case not, I wanted to send a note (a less than timely but hopefully useful one). Doug From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, August 10, 2010 12:33 PM To: arslist@ARSLIST.ORG Subject: Searching for CIs with specific related records ** I have a requirement to be able to search for CIs with specific related records with a specific attribute value. For instance: I create an RFC to upgrade all Windows 2003 servers to Service Pack 3. To do that, I need to identify which Windows Servers have a 2003 OS that is at SP 2 or below. The problem is that in ITSM 7.5, the server and the OS are stored in separate CMDB tables. How would I go about setting up a query (apart from creating a DB join) that would help me locate only the CIs appropriate to the issue the RFC is addressing? This would ideally be from the Change Management application, though we could use the Asset Management application if it were the only way. Rick _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Searching for CIs with specific related records
Rick, Never satisfied Always something else you want. (which by the way is a good thing because it means you are looking for more things to be able to do more things) Not directly. There is an API call you can use to get the data. So, if you had the criteria and could pass it to something that could make the call, then return the data. But, I don't believe there is a way to just get the data from the CMDB result screen since that is not done in an AR System table. Doug From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Friday, August 27, 2010 12:23 PM To: arslist@ARSLIST.ORG Subject: Re: Searching for CIs with specific related records ** Thanks, Doug. I did find that function, and it works just as you described. If I may ask a followup, is it possible to take those final results and attach them to the RFC directly from the cross class search results? Rick From: Mueller, Doug doug_muel...@bmc.com Sender: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG Date: Fri, 27 Aug 2010 14:16:54 -0500 To: arslist@ARSLIST.ORG ReplyTo: arslist@ARSLIST.ORG Subject: Re: Searching for CIs with specific related records Rick, OK, it has been a few weeks. So, I am behind a little.. The operation you describe is a standard, supported operation within the CMDB. You can go to a CMDB screen directly and perform this search. You can request exactly what you want For class that holds OSes (OK, so I don't know the name) where value is Windows 2003 that is connected using a relationship of class y to the class that holds patches where the value of the patch is service pack 3 And to go further, it could be Computer systems that are connected to OSes using relationship z and the query from above to find the systems rather than the OS instances. No joins need to be created. No special preparation. You can do a multi-class search following relationships and get back a result of the system following the cross class qualification. Hopefully, you have found this by now. But, just in case not, I wanted to send a note (a less than timely but hopefully useful one). Doug From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, August 10, 2010 12:33 PM To: arslist@ARSLIST.ORG Subject: Searching for CIs with specific related records ** I have a requirement to be able to search for CIs with specific related records with a specific attribute value. For instance: I create an RFC to upgrade all Windows 2003 servers to Service Pack 3. To do that, I need to identify which Windows Servers have a 2003 OS that is at SP 2 or below. The problem is that in ITSM 7.5, the server and the OS are stored in separate CMDB tables. How would I go about setting up a query (apart from creating a DB join) that would help me locate only the CIs appropriate to the issue the RFC is addressing? This would ideally be from the Change Management application, though we could use the Asset Management application if it were the only way. Rick _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
