Our freebies <http://www.softwaretoolhouse.com/freebies/index.html> Forms and
Fields spreadsheet seems to have been missing a “Join Map” column in the Forms
sheet – which always did show up in the text version of Meta-Schema’s output .
So, I added it and replaced all our freebies to include the columns. There may
be other enhancements depending on how long ago you got it.
Using an Excel filter on the Join Map column for contains “CTM:People” and
contains “CTM:Support Group” returns 15 rows:
CTM:PeopleUserSupportGroupFunctionalRole
CTM:PeopleUserSupportGroupFunctionalRoleLookup
CTM:Ppl Search-SupportGrpFuncR
CTM:PplPermissionSupGrpFuncRoleJoin
CTM:PPL-SptGrpFuncRole-ITSkills
CTM:PPLSupptGrpAscFcnRoleLkUp
CTM:Service Company_SupportGroup_Permission_Join
CTM:Service_Company_Support_Group_Role_People_Assoc_Join
CTM:Support Group Functional Role People Assoc Join
CTM:Support Group Permission People Join
CTM:SupportGroupAssociationLookUpJoin_PMC
CTM:SupportGroupFunctionalRolePeopleLookUp
CTM:SupportGrpFuncRoleAlJoin_PMC
CTM:SupportGrpFuncRoleAlpplPermJoin_PMC
CTM:SupportGrpFuncRoleJoin_PMC
CTM:SupportGrpFuncRolePplPermJoin_PMC
CTM:SupportGrpPplPermJoin_PMC
RKM:KCS:CoachCoachee_PPL_SGA_SG_PermGrp_Join
RKM:KCS:CoachCoachee_PPL_SGA_SG_PermGrp_PPL_Join_PPL_Join
I admit to having some trouble understanding the output when the join goes deep
and added “Schema numbering” to make things a bit more readable when the join
is 4 or more levels deep. A simple join will have Schema 1: and Schema 2:. If
1 is a join, it will have Schema 1.1 and 1.2. etc. The number of levels is
the number of dots plus 1 😊
I sorted the sheet on len(join map) and got AST:Console_Search_Full with 8
levels depth on one branch and 7 on another two branches. I wonder how long a
search would take on this one 😊:
Type: Outer, Referential integrity: enforced, Delete option: None;
Qual: ($Instance_Id$ = 'Source_InstanceId');
Schema 1: AST:Console_PeopleProcOSRack (
Type: Outer, Referential integrity: enforced, Delete option: None;
Qual: ($Instance_Id$ = 'Source.InstanceId');
Schema 1.1: AST:Console_PeopleProcOS (
Type: Outer, Referential integrity: enforced, Delete option: None; Qual:
($Instance_Id$ = 'Source.InstanceId');
Schema 1.1.1: AST:Console_PeopleProc (
Type: Outer, Referential integrity: enforced, Delete option: None; Qual:
($Instance_Id$ = 'Source.InstanceId');
Schema 1.1.1.1: AST:Console_People (
Type: Outer, Referential integrity: enforced, Delete option: None; Qual:
($Reconciliation Identity$ = 'AssetInstanceId');
Schema 1.1.1.1.1: AST:BaseElement (
Type: Outer, Referential integrity: enforced, Delete option: None;
Qual: (($ReconciliationIdentity$ = 'ReconciliationIdentity') OR
('ReconciliationIdentity' = $InstanceId$));
Schema 1.1.1.1.1.1: BMC.CORE:BMC_BaseElement
Schema 1.1.1.1.1.2: AST:Attributes )
Schema 1.1.1.1.2: AST:Console_People_Rel )
Schema 1.1.1.2: AST:Console_Proc_Rel (
Type: Inner, Referential integrity: enforced, Delete option: None;
Qual: (($Instance Id$ = 'Destination.InstanceId') AND (('MarkAsDeleted' =
"No") OR ('MarkAsDeleted' = $NULL$)));
Schema 1.1.1.2.1: AST:Processor (
Type: Outer, Referential integrity: enforced, Delete option: None;
Qual: (($ReconciliationIdentity$ = 'ReconciliationIdentity') OR
('ReconciliationIdentity' = $InstanceId$));
Schema 1.1.1.2.1.1: BMC.CORE:BMC_Processor (
Type: Inner, Referential integrity: enforced, Delete option: None;
Qual: ('ClassId' = "BMC_PROCESSOR");
Schema 1.1.1.2.1.1.1: OBJSTR:CatClassStub
Schema 1.1.1.2.1.1.2: BMC.CORE:BMC_HardwareSystemComponent (
Type: Inner, Referential integrity: enforced, Delete option: None;
Qual: ($InstanceId$ = 'InstanceId');
Schema 1.1.1.2.1.1.2.1: BMC.CORE:BMC_HardwareSystemComponent_
Schema 1.1.1.2.1.1.2.2: BMC.CORE:BMC_BaseElement ) )
Schema 1.1.1.2.1.2: AST:Attributes )
Schema 1.1.1.2.2: BMC.CORE:BMC_BaseRelationship ) )
Schema 1.1.2: AST:Console_OS_Rel ( Type: Inner, Referential integrity:
enforced, Delete option: None;
Qual: (($Instance Id$ = 'Destination.InstanceId') AND (('MarkAsDeleted' =
"No") OR ('MarkAsDeleted' = $NULL$)));
Schema 1.1.2.1: AST:OperatingSystem (
Type: Outer, Referential integrity: enforced, Delete option: None;
Qual: (($ReconciliationIdentity$ = 'ReconciliationIdentity') OR
('ReconciliationIdentity' = $InstanceId$));
Schema 1.1.2.1.1: BMC.CORE:BMC_OperatingSystem (
Type: Inner, Referential integrity: enforced, Delete option: None;
Qual: ($InstanceId$ = 'InstanceId');
Schema 1.1.2.1.1.1: BMC.CORE:BMC_OperatingSystem_
Schema 1.1.2.1.1.2: BMC.CORE:BMC_SystemSoftware (
Type: Inner, Referential integrity: enforced, Delete option: None;
Qual: ($InstanceId$ = '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:[email protected]] On Behalf Of Arner, Todd
Sent: November-30-17 11:19 AM
To: [email protected]
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:[email protected]> [email protected] 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
[email protected]
https://mailman.rrr.se/cgi/listinfo/arslist
