Video Screencast Help

SQL Command Help.

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

hello,

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.

thanks

 

 

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 | www.trace3.com

SOLUTION