RE: Report on Support Group Members
stanceId$ = 'InstanceId'); Schema 1.1.2.1.1.2.1: BMC.CORE:BMC_SystemSoftware_ Schema 1.1.2.1.1.2.2: BMC.CORE:BMC_LogicalSystemComponent ( Type: Inner, Referential integrity: enforced, Delete option: None; Qual: ($InstanceId$ = 'InstanceId'); Schema 1.1.2.1.1.2.2.1: BMC.CORE:BMC_LogicalSystemComponent_ Schema 1.1.2.1.1.2.2.2: BMC.CORE:BMC_BaseElement ))) Schema 1.1.2.1.2: AST:Attributes ) Schema 1.1.2.2: BMC.CORE:BMC_BaseRelationship )) Schema 1.2: AST:Console_Rack_Rel ( Type: Inner, Referential integrity: enforced, Delete option: None; Qual: (($Instance Id$ = 'Destination.InstanceId') AND (('MarkAsDeleted' = "No") OR ('MarkAsDeleted' = $NULL$))); Schema 1.2.1: AST:Rack ( Type: Outer, Referential integrity: enforced, Delete option: None; Qual: (($ReconciliationIdentity$ = 'ReconciliationIdentity') OR ('ReconciliationIdentity' = $InstanceId$)); Schema 1.2.1.1: BMC.CORE:BMC_Rack ( Type: Inner, Referential integrity: enforced, Delete option: None; Qual: ('ClassId' = "BMC_RACK"); Schema 1.2.1.1.1: OBJSTR:CatClassStub Schema 1.2.1.1.2: BMC.CORE:BMC_HardwarePackage ( Type: Inner, Referential integrity: enforced, Delete option: None; Qual: ($InstanceId$ = 'InstanceId'); Schema 1.2.1.1.2.1: BMC.CORE:BMC_HardwarePackage_ Schema 1.2.1.1.2.2: BMC.CORE:BMC_HardwareSystemComponent ( Type: Inner, Referential integrity: enforced, Delete option: None; Qual: ($InstanceId$ = 'InstanceId'); Schema 1.2.1.1.2.2.1: BMC.CORE:BMC_HardwareSystemComponent_ Schema 1.2.1.1.2.2.2: BMC.CORE:BMC_BaseElement ))) Schema 1.2.1.2: AST:Attributes ) Schema 1.2.2: BMC.CORE:BMC_BaseRelationship )) Schema 2: AST:Console_Proc_Rel_Count I’ve updated the freebies to include this column and offered a text file containing all workflow as well. Note that there will be some spurious forms in that 250Mb text file. With the right editor finding all references of a field is a simple search. Cheers, Ben Chernys Senior Software Architect Canada / Deutschland Mobile: +49 171 380 2329 GMT - 7 + [ DST ] Mobile +1 403 554 0887 Email: Ben.Chernys_AT_softwaretoolhouse.com <mailto:Ben.Chernys_AT_softwaretoolhouse.com> Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and our Freebies Section for ITSM Forms and Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as a complete tree and checking associatuions. Archive output to different servers, HTML pages with links to attachments or archive forms. Pre ITSM 9.1.02? Clarify? Roll your own? No problem! You can keep your valuable data! <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd Sent: November-30-17 11:19 AM To: arslist@ARSLIST.ORG Subject: Report on Support Group Members ** I am trying to run a report that lists all support groups and the people that belong to the group. I thought this would be an easy task, but I am not finding any forms that contain that data to report off of. Can anyone point me in the right direction? Thanks, Todd Arner _ The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be protected under state or federal law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please forward the communication to <mailto:no...@glhec.org> no...@glhec.org immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Report on Support Group Members
I was able to do this doing Smart Reporting. I also set up a report that one gets sent out if a support group has no members. Toby Sent from my iPhone > On Nov 30, 2017, at 1:30 PM, Murnane, Phil <phil.murn...@windward.com> wrote: > > ** > Hi Todd, > > Check out ARInside – it’s invaluable for learning how the OOB applications > work (e.g. which Join forms are built from CTM:People). > > HTH, > --Phil > > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Schaefer, Barb > Sent: Thursday, November 30, 2017 1:31 PM > To: arslist@ARSLIST.ORG > Subject: Re: Report on Support Group Members > > ** > Hi Todd, > > Did you try the CTM:Service Company_SupportGroup_Permission_Join form? > > Sincerely, > > Barb Schaefer > IT Process Improvement Analyst - Information Technology > Phone: 414-777-5115 Pager: 414-590-6825 > E-mail: barbara.schae...@froedtert.com > > Froedtert & The Medical College of Wisconsin > 400 Woodland Prime, Suite 200 > N74 W12501 Leatherwood Court > Menomonee Falls, WI 53051-4490 > froedtert.com > > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd > Sent: Thursday, November 30, 2017 12:19 PM > To: arslist@ARSLIST.ORG > Subject: Newsletter / Marketing: Report on Support Group Members > > ** > I am trying to run a report that lists all support groups and the people that > belong to the group. I thought this would be an easy task, but I am not > finding any forms that contain that data to report off of. Can anyone point > me in the right direction? > > Thanks, > Todd Arner > The information contained in this communication may be confidential, is > intended only for the use of the recipient(s) named above, and may be > protected under state or federal law. If the reader of this message is not > the intended recipient, you are hereby notified that any dissemination, > distribution, or copying of this communication, or any of its contents, is > strictly prohibited. If you have received this communication in error, please > forward the communication to no...@glhec.org immediately and destroy or > delete the original message and any copy of it from your computer system. If > you have any questions concerning this message, please contact the sender. > _ARSlist: "Where the Answers Are" and have been for 20 years_ > Confidentiality Notice: This e-mail message, including any attachments, is > for the sole use of the intended recipient(s) and may contain confidential > and privileged information. Any unauthorized review, use, disclosure or > distribution is prohibited. If you are not the intended recipient, please > contact the sender by reply e-mail and destroy all copies of the original > message. > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Report on Support Group Members
Hi, The data is in CTM:SupportGroupAssociationLookUpJoin_PMC. == Julia James From: arslist automatic digest system <lists...@arslist.org> To: arslist@ARSLIST.ORG Date: 11/30/2017 05:02 PM Subject:arslist Digest - 29 Nov 2017 to 30 Nov 2017 (#2017-235) Sent by:"Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> There are 4 messages totaling 751 lines in this issue. Topics of the day: 1. Report on Support Group Members (4) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" -- Date:Thu, 30 Nov 2017 18:19:26 + From:"Arner, Todd" <tar...@glhec.org> Subject: Report on Support Group Members I am trying to run a report that lists all support groups and the people that belong to the group. I thought this would be an easy task, but I am not finding any forms that contain that data to report off of. Can anyone point me in the right direction? Thanks, Todd Arner -- The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be protected under state or federal law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please forward the communication to no...@glhec.org immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" -- Date:Thu, 30 Nov 2017 18:30:38 + From:"Schaefer, Barb" <barbara.schae...@froedtert.com> Subject: Re: Report on Support Group Members Hi Todd, Did you try the CTM:Service Company_SupportGroup_Permission_Join form? Sincerely, Barb Schaefer IT Process Improvement Analyst - Information Technology Phone: 414-777-5115 Pager: 414-590-6825 E-mail: barbara.schae...@froedtert.com< mailto:barbara.schae...@froedtert.com> Froedtert & The Medical College of Wisconsin 400 Woodland Prime, Suite 200 N74 W12501 Leatherwood Court Menomonee Falls, WI 53051-4490 froedtert.com From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd Sent: Thursday, November 30, 2017 12:19 PM To: arslist@ARSLIST.ORG Subject: Newsletter / Marketing: Report on Support Group Members ** I am trying to run a report that lists all support groups and the people that belong to the group. I thought this would be an easy task, but I am not finding any forms that contain that data to report off of. Can anyone point me in the right direction? Thanks, Todd Arner The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be protected under state or federal law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please forward the communication to no...@glhec.org<mailto:no...@glhec.org > immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" -- Date: Thu, 30 Nov 2017 19:30:18 + From:"Murnane, Phil" <phil.murn...@windward.com> Subject: Re: Report on Support Group Members Hi Todd, Check out ARInside< https://ur
Re: Report on Support Group Members
Todd, I have Remedy Analytics so the way I did it was to create a universe object by linking the following views: CTM:Support Group to ctm:supportgroupassocPeoplelook by the support group id ctm:supportgroupassocPeoplelook to ctm:people remedy by login_id Even if you don't have Analytics, you can join the views in the same way and report off the join. From: "Arner, Todd" <tar...@glhec.org> To: arslist@ARSLIST.ORG, Date: 11/30/2017 01:20 PM Subject: Report on Support Group Members Sent by:"Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> ** I am trying to run a report that lists all support groups and the people that belong to the group. I thought this would be an easy task, but I am not finding any forms that contain that data to report off of. Can anyone point me in the right direction? Thanks, Todd Arner The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be protected under state or federal law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please forward the communication to no...@glhec.org immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Report on Support Group Members
Hi Todd, Check out ARInside<http://arinside.org/> - it's invaluable for learning how the OOB applications work (e.g. which Join forms are built from CTM:People). HTH, --Phil From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Schaefer, Barb Sent: Thursday, November 30, 2017 1:31 PM To: arslist@ARSLIST.ORG Subject: Re: Report on Support Group Members ** Hi Todd, Did you try the CTM:Service Company_SupportGroup_Permission_Join form? Sincerely, Barb Schaefer IT Process Improvement Analyst - Information Technology Phone: 414-777-5115 Pager: 414-590-6825 E-mail: barbara.schae...@froedtert.com<mailto:barbara.schae...@froedtert.com> Froedtert & The Medical College of Wisconsin 400 Woodland Prime, Suite 200 N74 W12501 Leatherwood Court Menomonee Falls, WI 53051-4490 froedtert.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd Sent: Thursday, November 30, 2017 12:19 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Newsletter / Marketing: Report on Support Group Members ** I am trying to run a report that lists all support groups and the people that belong to the group. I thought this would be an easy task, but I am not finding any forms that contain that data to report off of. Can anyone point me in the right direction? Thanks, Todd Arner The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be protected under state or federal law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please forward the communication to no...@glhec.org<mailto:no...@glhec.org> immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Report on Support Group Members
Hi Todd, Did you try the CTM:Service Company_SupportGroup_Permission_Join form? Sincerely, Barb Schaefer IT Process Improvement Analyst - Information Technology Phone: 414-777-5115 Pager: 414-590-6825 E-mail: barbara.schae...@froedtert.com<mailto:barbara.schae...@froedtert.com> Froedtert & The Medical College of Wisconsin 400 Woodland Prime, Suite 200 N74 W12501 Leatherwood Court Menomonee Falls, WI 53051-4490 froedtert.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd Sent: Thursday, November 30, 2017 12:19 PM To: arslist@ARSLIST.ORG Subject: Newsletter / Marketing: Report on Support Group Members ** I am trying to run a report that lists all support groups and the people that belong to the group. I thought this would be an easy task, but I am not finding any forms that contain that data to report off of. Can anyone point me in the right direction? Thanks, Todd Arner The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be protected under state or federal law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please forward the communication to no...@glhec.org<mailto:no...@glhec.org> immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Report on Support Group Members
I am trying to run a report that lists all support groups and the people that belong to the group. I thought this would be an easy task, but I am not finding any forms that contain that data to report off of. Can anyone point me in the right direction? Thanks, Todd Arner -- The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be protected under state or federal law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please forward the communication to no...@glhec.org immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"