• State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 97 subscribers
  • Views 3012 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

tasks need to be run by SQL statement, no GUI option

gary.lam

some of the tasks have to be run from object browser's sql, is that a document listed out these tasks with associated sql statement?
Thx

Parents
  • 0
    example :
    1. reactive inactive employees record
    update Person set isinactive ='false' where centralaccount = 'xxxxx'
    2. remove ad account from a linked person record
    update adsaccount set UID_Person = NULL where samaccountname = 'xxxxx'

    Thanks
Reply
  • 0
    example :
    1. reactive inactive employees record
    update Person set isinactive ='false' where centralaccount = 'xxxxx'
    2. remove ad account from a linked person record
    update adsaccount set UID_Person = NULL where samaccountname = 'xxxxx'

    Thanks
Children
No Data