#1 2017-03-29 06:40:10

stephie22
Member
Registered: 2017-03-09

Dashboards

Good Day, I really need to get rid of dashboards. I have the community verison and cant run scripts. I need to delete dashboards from 60 users profiles by deleting it directly from the database. I know its not ideal, but I really need to. Please explain to me how I am able to do this.

Offline

#2 2017-03-29 11:57:25

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Dashboards

Hi stephie22,

as I told you here: https://forum.reportserver.net/viewtopic.php?id=797, you have several possibilities:
1. install a demo version, so you will have an enterprise version for a period of time. During this period of time, you can run scripts, and do whatever the enterprise version can. So you could delete the dashboards with a script.
2. if you really want to delete the records manually from the database, you have to analyze the records changed when you manually add a dashboard, e.g. by comparing the before-state with the after-state of the tables. Then, based on this information, you can decide which records have to be deleted. But, again, manually deleting records from the internal db is not a good idea, since you can damage your db easily.

Another possiblity, which would require some tedious manual work, would be:
3. With the SU permission ( https://reportserver.net/en/guides/admi … anagement/ for more information), you could impersonate your users, so you could sit one hour or two logging-in as your users and deleting their dashboards.

Cheers,
Eduardo

Offline

Board footer

Powered by FluxBB