ITMS Administrator Group

Hi,

Does anyone have a SQL query ready to change ownership on several items? I have found this arctile, however this looks for owners which are not present anymore. I am looking for a query where if owner = 'xxx' change to '2E1F478A-4986-4223-9D1E-B5920A63AB41' -- Symantec Administrators.

Thanks

Stefan

From the Article:

Versions 7.5 and 7.6

select se.OwnerGuid
from SecurityEntity se
left join Item i on i.Guid = se.OwnerGuid
where i.Guid is null

version 8.0 and later

select se.OwnerGuid
from SecurityEntity se
left join Item i on i.Guid = se.OwnerGuid
where i.Guid is null and OwnerGuid <> '0FFFFFFF-FFFF-FFFF-FFFF-FFFFFFFFFFFF'

If you test the SELECT first so you know it's bringing back the correct Items you wish to update,

You should just be able to change the WHERE clause.

OwnerGuid <> '0FFFFFFF-FFFF-FFFF-FFFF-FFFFFFFFFFFF'

Using OwnerGuid <> '0FFFFFFF-FFFF-FFFF-FFFF-FFFFFFFFFFFF' will change objects also which has other owners. I was thinking the same however as said I would like to only change the owner for objects with a specific owner.

Sorry for the confusion,

I was copying in the original SQL so you knew where to change it.

OwnerGuid <> '0FFFFFFF-FFFF-FFFF-FFFF-FFFFFFFFFFFF'

i.e change to the Guid you want to amend,

OwnerGuid = '[YOUR GUID HERE]'