Book a Demo

Author Topic: Script Table  (Read 4040 times)

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1353
  • Karma: +121/-10
  • Its the results that count
    • View Profile
Script Table
« on: May 21, 2014, 11:51:33 am »
We have a central repository (oracle) with lots of vb and javascripts by various authors and I need to create a report that identifies the author so we can start managing migration.
When I looked in the t_script table I found a column called ScriptAuthor that has GUID's in it like {5E08D22F-FBF6-4a91-95FE-3C93713AF09F}. Can any one point me to what the GUID's reference in the from the column ScriptAuthor in t_script table.
Happy to help
:)

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1353
  • Karma: +121/-10
  • Its the results that count
    • View Profile
Re: Script Table
« Reply #1 on: May 21, 2014, 12:18:01 pm »
Think I've figured this one out. There are scripts and groups in the t_script table. Creating a group creates the GUID in the ScriptName column. When a script is created the Group GUID in ScriptName is used to  populate the ScriptAuthor column.
So in short there is no way to identify the author of any script.  :(
Fortunately for me there is a correlation between the group and the author so I can make that connection.  
Happy to help
:)

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Script Table
« Reply #2 on: May 21, 2014, 06:39:06 pm »
I always wondered why there is so little control over that scripting since you can do such bad things with it. OTOH nobody ever seemed to have cared. Maybe since you can do all that evil through the API - also without any control. Or because you can simply bypass it all via the RDBMS.

q.