Using PowerShell for SSAS to check service status and database availability
In my first article about PowerShell we saw a brief introduction to PowerShell, learning how to use the basic commands, how to open PowerShell, how to Navigate in SSAS and how to process objects. In part 2, we learned how to work with variables and how to create SSAS backups using the current date and variables. Finally we learned to run MDX and XMLA scripts.
In part 3, there are tips to control the following:
- PowerShell commands to verify the SSAS Service status
- Send a message if the SSAS service is down
- Verify the hard disk space for the SSAS database
- Schedule a script to verify the database status every hour