RE: Report on Support Group Members

2017-12-15 Thread Ben Chernys
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

2017-12-09 Thread toby . w . mitchell
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

2017-12-01 Thread Julia James
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

2017-11-30 Thread Ben Cantatore
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

2017-11-30 Thread Murnane, Phil
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

2017-11-30 Thread Schaefer, Barb
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

2017-11-30 Thread Arner, Todd
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"