sys.dm_db_index_usage_stats from SMO with powershell script

Asked Oct 05 '22 at 14:30

Active Oct 05 '22 at 17:24

Viewed 72 times

I am trying to get the sys.dm_db_index_usage_stats from SMO with powershell script. Currently script looks like this:

[system.reflection.assembly]::LoadWithPartialName("Microsoft.SQLServer.Smo") | out-null
$SQLServer = "name"
$srv = new-object ("Microsoft.SqlServer.Management.Smo.Server") $SQLServer
$srv.Databases[‘master’].views | Select name

This way it prints all the available metrics. sys.dm_db_index_usage_stats is among them. But how do I get the value of sys.dm_db_index_usage_stats? Please advice

edited Oct 05 '22 at 17:24

Ben Thul

31,080
4
45
68

asked Oct 05 '22 at 14:30

evil-cat

Why not use ordinary `select` to query the DMV? There's no need to use SMO. – vonPryz Oct 05 '22 at 15:32
how would it look like then? – evil-cat Oct 06 '22 at 06:52

sys.dm_db_index_usage_stats from SMO with powershell script

0 Answers0