Automic Workload Automation

  • 1.  XSLT for export user/usergroup objects

    Posted Apr 11, 2018 01:46 PM
    This is a long shot but has anybody built and XSLT files for putting exported user or group files into a readable format.
    It would be extremely useful for audit if I could export the users and groups, transform them and print them all at once.


  • 2.  XSLT for export user/usergroup objects

    Posted Apr 11, 2018 02:29 PM
    Here is a database query I use with my auditors.  I shows who is in which security groups, when they last signed on, and weather or not the user has been set inactive.  (We don't delete users because doing so logically orphans their history.)

    select oh2.oh_name as 'GROUP'
         , oh2.oh_client as 'CLIENT'
         , oh1.oh_name as 'USER'     
          , case USR_Active      
               when 0 then 'INACTIVE'
               else ' '
            end as STATE
          , USR_LastSession as LAST_USED
    from   oh as oh1
          ,oh as oh2
           ,usr
           ,usrg
           ,USG 
    where oh1.oh_idnr=USR_OH_Idnr
    and   USRG_USR_Idnr=USR_OH_Idnr 
    and   usrg_usg_idnr = usg_oh_idnr
    and   USG_OH_Idnr=oh2.oh_idnr 
    order by 1, 2, 3