-
1. Re: Mail need to be triggered to site admin when ever site space reaches to 80%
Matt Coles
Aug 28, 2017 10:42 PM
Hi Sudhakar. What have you tried doing so far, and what is currently blocking you from getting farther along in building this alert?
-
2. Re: Mail need to be triggered to site admin when ever site space reaches to 80%
Hello MATT,
I've followed the steps provided in the install guide. I've pulled the data required tables from Tableau Server Database. I'm breaking my head on writing a condition for the above requirement.
Please find the below screen shot.
Thanks & Regards,
Sudhakar Reddy
-
3. Re: Mail need to be triggered to site admin when ever site space reaches to 80%
Matt Coles
Aug 30, 2017 7:24 AM
2 of 2 people found this helpfulOkay, that helps. So you know how big each Site is, and you want to be able to alert yourself whenever a Site reaches 80% of it's storage_quota? You need to create a calculated field that divides SUM([size in GB[) / [Storage Quota] * 100. That will give you the percentage of how big each Site is. Then add that field to the Filter shelf and set it to > 80. Publish the workbook, then subscribe on a daily VizAlerts schedule. Good to go.
Let me know if that answers your question.
-
4. Re: Mail need to be triggered to site admin when ever site space reaches to 80%
Hello MATT,
Thanks for your response.
I'm unable to find out the data source in tableau database that has the information which shows total size () of each site.
Regards,
Sudhakar Reddy
-
5. Re: Mail need to be triggered to site admin when ever site space reaches to 80%
Matt Coles
Sep 27, 2017 7:01 AM
Use the TS Content data source that I built for this.
-
6. Re: Mail need to be triggered to site admin when ever site space reaches to 80%
Hello MATT,
can you please help me out , for finding the site space being utilized . once i get the site storage quota being used then i will be able to use the total storage quota being assigned to specific size. Once i get used space for each site then i can use (used space / total space ) *100 and from there i can continue. i'm not able to find the space being utilized for each site.
Any help is appreciated.
Regards,
Sudhakar Reddy
-
7. Re: Mail need to be triggered to site admin when ever site space reaches to 80%
Matt Coles
Oct 6, 2017 6:56 AM
If you're using the TS Content data source, like I suggested, then here are the fields you want, I believe (along with Site Name):
-
8. Re: Mail need to be triggered to site admin when ever site space reaches to 80%
Hello MATT,
I've tried connecting to TS Content DS, Site space being utilized is absolutely perfect but actual Site Space being allocated to each site is not showing the correct values.
When tried using the Storage Quota (MB) as total allocated space for the site, the values are not correct as expected. Can you please help me out with the field that need to be considered to get total allocated space for the site.
Regards,
Sudhakar Reddy
-
9. Re: Mail need to be triggered to site admin when ever site space reaches to 80%
Matt Coles
Oct 9, 2017 7:31 AM
The storage quota is per-site, which means the value will be repeated for all Workbook, Datasources, etc. So if you are SUMming, the value will be repeated and added to itself again and again. You need to aggregate it differently. Try MIN or MAX, or possibly a LOD calc.
