Delete Policy

[Alex Moreira]

Hello guys,

It is possible to delete a direct policy by the database or command line?

For DSM Explorer can not, no longer exists.

Thanks!

[Gordon Lamothe]

What kind of policy is this ?

 

A Event based policy ?

A Query Based  policy ?

or a Software based Policy ?

 

Run the following SQL Query:

 

 

mdb

 

 

select name,* from usd_job_cont where type =4

 

Do you see the policy there ?

 

 

mdb

 

delete from usd_job_cont where type =4 and name = '<name from Query above>'

 

 

 

[Alex Moreira]

A Query Based  policy

[Gordon Lamothe]

 

use mdb

select  polname, * FROM POLIDEF

use mdb

delete  from polidef where polname = '<Name of Policy from above>'

 

[Alex Moreira]

Gordon,

This "select" did not bring the policies I would like to delete.

[Jean-Yves Guiblet]

Hi Alex,

 

The "Query Based" Policies are stored in table polidef

 

How do you detect that the policy still exists as it does not appear in DSM Explorer anymore ?

Maybe it is a "Configuration Policy" ?

 

You could check with these queries for other type of policies :

 

Event Based Policy :

select eptitle,* from amepdef

 

Software Policy :

select name,* from usd_job_cont where type=4

 

Configuration Policy :

select name,* from csm_object where class="2000"

 

Regards,

Jean-Yves

[Alex Moreira]

Jean,

Actually it was even Configuration Policy.

Thank you!

[Jean-Yves Guiblet]

Hi Alex,

 

If it is a configuration Policy, could you see it in the result of this query ?

 

select name,* from csm_object where class="2000"

 

It is possible to remove a configuration policy directly applied on a computer by right-clicking on the folder "Configuration Policy" of the machine and select "Remove all directly applied policies"

 

 

 

Thanks.

Regards,

Jean-Yves