-
1. Re: Mail need to be triggered to site admin when ever site space reaches to 80%
Matt ColesAug 28, 2017 10:42 PM (in response to sudhakar reddy)
Hi Sudhakar. What have you tried doing so far, and what is currently blocking you from getting farther along in building this alert?
-
3. Re: Mail need to be triggered to site admin when ever site space reaches to 80%
Matt ColesAug 30, 2017 7:24 AM (in response to sudhakar reddy)
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%
sudhakar reddy Sep 27, 2017 6:51 AM (in response to Matt Coles)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 ColesSep 27, 2017 7:01 AM (in response to sudhakar reddy)
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%
sudhakar reddy Oct 6, 2017 4:20 AM (in response to Matt Coles)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
-
8. Re: Mail need to be triggered to site admin when ever site space reaches to 80%
sudhakar reddy Oct 9, 2017 6:37 AM (in response to sudhakar reddy)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 ColesOct 9, 2017 7:31 AM (in response to sudhakar reddy)
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.