# ------------------------------------------------------------------------------------------------------------------------------------------------
# ------------------------------------------------------------------------------------------------------------------------------------------------
# -- Script PowerShell de Monitoring SNMP
# -- Materiel visé : Base de donnée SQL serveur 2008
# -- Elements : surveillance espace used/available d'une DB
# -- PSVersion : 5.1.16299.98
# -- Créé par la société : FOLDER
# -- Créateur(s) : T.Cansado
# ------------------------------------------------------------------------------------------------------------------------------------------------
# ------------------------------------------------------------------------------------------------------------------------------------------------

#---- IMPORT ---------------------------------
Import-Module SqlServer

#---- VARIABLES ------------------------------
$user = "ALPESDEIS\RG"
$pwd = “RGsyst3m” | ConvertTo-SecureString -AsPlainText -Force

$SQLServer = "srv-vcenter\VIM_SQLEXP" #use Server\Instance for named SQL instances!
$SQLDBName = "VIM_VCDB"

#---- CONNEXION A LA BASE DE DONNEE ----------
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = "Server = $SQLServer; Database = $SQLDBName; User ID= $user; Password= $pwd"

#---- ENVOI DE LA COMMANDE SQL ---------------
$CMDSQLSPACE = Invoke-Sqlcmd -ServerInstance "$SQLServer" -Query "USE VIM_VCDB ; EXEC sp_spaceused ;"

#---- TRAVAIL SUR VARIABLE -------------------
$CMDSQL_DBSPACE = $CMDSQLSPACE | Format-Table -Property database_size -HideTableHeader
$CMDSQL_DBSPACEFREE = $CMDSQLSPACE | Format-Table -Property "unallocated space" -HideTableHeader

#---- TEST D'AFFICHAGE VARIABLE --------------
#$CMDSQL_DBSPACE
#$CMDSQL_DBSPACEFREE


#---- VARIABLE EN SORTIS POUR RG -------------
write-output $CMDSQL_DBSPACE
$host.ui.WriteErrorLine($CMDSQL_DBSPACEFREE)
exit