Currently we are using many servers and every servers is connected to "n" number of databases.
Due to cost optimization,my company has decided to remove for not using database's for the past few months/years.
for example,
1. we want the details if the DB have not been used for the past few months/years.
2. we want the details if the Table have not been done any transaction (DML) for the past few months/years.
3. We want the details when the DB is created and through in whick login this db has created
4. How many login account have been connected for each database.
Is it possible to get all the above details in the Power BI Dashboard..?
If i get all the above about the server and DB details, it will be helpful for the management to save the cost for not using databases.
