Symantec Management Platform (Notification Server)

 View Only
  • 1.  ITA Is Not Recording Any Dates Beyond Dec 31 2019

    Posted Jan 16, 2020 01:24 PM

    The tech article TECH257100 offer an SQL script to correct the problem and we are trying to figure out how to execute it.

    It is not like a regular DB SQL script, it modify IT analytic

    does someone know who to execute it ?

     

    https://support.symantec.com/us/en/article.tech257100.html

     

    Thanks

    Dany



  • 2.  RE: ITA Is Not Recording Any Dates Beyond Dec 31 2019

    Posted Jan 16, 2020 03:01 PM
    The “insert into DateDim” part is how the date(s) are added to the “DateDim“ table, the “select” part is getting the values that will added. If you are ever making changes to a Table you could always make a backup first.


  • 3.  RE: ITA Is Not Recording Any Dates Beyond Dec 31 2019

    Posted Jan 16, 2020 04:01 PM

    thanks.   usually, i'm quite familliar about modifying an SQL table.   But this time it about a modification of the SQL analytic database and I don't understand how to modify it with SQL server management studio