Hello,
I have a question that hopefully someone can help me.
I have a xlsx file called
tempxlsserverhdrive1.xlsx.
It holds the following data
|
Date
|
Free Megabytes
|
|
7/11/2017 0:00
|
46816.56
|
|
8/11/2017 0:00
|
46265.18
|
|
9/11/2017 0:00
|
45085.95
|
|
10/11/2017 0:00
|
46919.88
|
|
11/11/2017 0:00
|
47574.48
|
Now I am trying to use the powershell cmdlet
ImportExcel
But I can not work out how to create a line graphs from this data .
Here is a copy of my code
#import-module sqlps -DisableNameChecking
#Install-Module ImportExcel -Force
#Install-Module -Name SqlServer
# Initialize Hash Table Array
$tempEntry
=@()
$sqlquery
= @()
#remove any exisiting temp xlsx TO BE MOVE LATER ON TO THE BOTTOM OF THE POWERSHELL !!!
#if file exists then remove...
Remove-Item
-Path C:\scripts\tempxlsserverhdrive1.xlsx
#The SQL query will obtain the free MB from D volume.the server in the last 100 days
$sqlquery
= Invoke-Sqlcmd
-ServerInstance SQLSERVER.FQDN
-inputFile "C:\scripts\Disk-Free-report-100days.sql"
#I only need the date and the amount of free space
$tmpentry
= $sqlquery
| select
date,'free megabytes'
#producing the Xlsx file
$tmpentry
| Export-Excel
-Path C:\scripts\tempxlsserverhdrive1.xlsx
I am suck. Can someone help me out ?
