IT Management Suite

 View Only
  • 1.  Where are script tasks being saved

    Posted Jul 04, 2016 01:52 AM

    hi,

    i'm looking for the location where the system store the user tasks (scripts mostly).

    is it in the DB or in files on the smp server?

    i need it for searching certian words in the scripts that i have to replace (vc name)..

     

    thanks

    mor



  • 2.  RE: Where are script tasks being saved

    Broadcom Partner
    Posted Jul 04, 2016 02:32 AM

    Hi mpereg,

    The Information is stored in the Database.
    You can find the information in the itemversiontable in the column state.
     

    Network23

     



  • 3.  RE: Where are script tasks being saved

    Posted Jul 04, 2016 02:36 AM

    can you give me the query? i can't find itemversiontable (just itemversions or itemversiondata)

    thanks

    mor



  • 4.  RE: Where are script tasks being saved
    Best Answer

    Posted Jul 04, 2016 02:39 AM

    ok found it in ItemVersionData table, state column under <![CDATA

    Select * from ItemVersionData

     

    Thanks

    mor