Video Screencast Help

SQL Command Help.

Created: 11 Jul 2014 • Updated: 11 Jul 2014 | 2 comments
This issue has been solved. See solution.


im looking for a command to report on what users archives are set to "do not delete" and "delete"

i have this script to actually set the user to "do not delete"

UPDATE Archive
SET DeleteExpiredItems = 0
WHERE ArchiveName IN ()

just need to report on it.


Operating Systems:

Comments 2 CommentsJump to latest comment

AndrewB's picture

select * from Archive where DeleteExpiredItems = 0


the second part you have, WHERE ArchiveName IN () is necessary only if you want to specify certain archive names. then it could look like

select * from Archive 

where DeleteExpiredItems = 0

and ArchiveName in (user 1, user 2, user 3, etc)

Andy Becker | Authorized Symantec Consultant | Trace3 | Symantec National Partner |