Removing user info from the Yellowfin Repository DB

The Yellowfin Repositorty DB used to store meta data for content (e.g. SQL generated) , configuration settings (e.g. Email, Scheduler), and also user login information. If wanting to obfuscate such rows, the following queries can help.

Please ensure you have a full backup prior to running any of these queries, and that some of these queries may need to be translated to your DBMS of choice; 


Configuration
update Configuration
set Configdata = NULL
where ConfigCode in (EXTERNALURL, LDAPBINDUSER,MOBILEAPPSTORELINK,SAVETODISKPATH,SMTP,SMTPPASSWORD,SMTPUSERNAME)

Event
Truncate Event
NOTE: If you need the event results, obviously don't truncate this. 

EventArchive
Truncate EventArchive

IpClass
Set EmailLeft = 'EL'+IPID
Set EmaiRight = NULL
where IpId is not NULL

IpContact
Set emailaddress = 'email' + IPID + '@sanitized.com’
Where IpId is not NULL

Person
Set Firstname='FN'+IPID
Set Lastname='LN'+IPID
Set PreferredName='PN'+IPID
Set FullName='FLN'+IPID
Where IPID is not NULL

ReportBroadcastResult
truncate table reportbroadcastresult 

ReportBroadcastRecipient
truncate reportbroadcastrecipient

ReportViewSource
Set Password=NULL
where SourceID is not NULL

If you are unsure about running the above, please reach out to the Yellowfin Support Team for further assistance.


Is article helpful?