Basic Help

[SkreeM1980]

Hi,

 

I've managed to use powershell to log some stats to SQL(every 5 minutes), and i really want to display the latest numbers from a certain table on a wallboard we have in the office. We have a piece of software that already lets me put content into zones on it. but i'm really struggling to write a working webpage that gets the info from SQL to display

 

Can anyone point me in the right direction (i've tried using AODDB recordset, but it seems to error with no details, and i managed to confuse myself totally with VS2012)

[howartp]

Do you need to use the SQL for the powershell you've written?

 

Or could CSV be used instead?

 

It depends on the nature of the stats/data but might be easier to get in/out of CSV than SQL.

[SkreeM1980]

I happen to have the data in csv and sql (csv was.step one in my powershell)

[howartp]

Do you have PHP available on your webserver?

 

Which software is running the TV - presumably some sort of digital signage?

[SkreeM1980]

The tv is running using statseeker, I can put php on a webserver

[howartp]

Actually...

 

If you've got the data in powershell, there's a command to output it to HTML.

 

I've not used it yet though!

 

(Ive done lots of PHP and CSV processing, but I've only just entered the world of Powershell so haven't converted my old routines over)

 

Something like write-output -format: html

Edited October 30, 2014 by howartp

[howartp]

Windows PowerShell Tip: Creating Formatted HTML Output

 

Get-Service | Select-Object Status, Name, DisplayName | ConvertTo-HTML | Out-File C:\Scripts\Test.htm