Trouble with multiple Device ID's (Local Hard drives)

[jvierra]

What is on line 46?

[mtartaglia]

Invoke-Sqlcmd -ServerInstance $sqlserver -Database $database -Username $sqluser -Password $sqlpass -Query $query

[jvierra]

Something is wrong with your SQL.

[mtartaglia]

This is what I have but this doesn't look right.

$tmplt = @'
UPDATE dbo.NoendDate (EndDate, EndTime, EndSpace)
VALUES('{0}', '{1}', '{2}')
'@

[jvierra]

If any value is null the update sql will fail. Print the final statements to the console.

[jvierra]

Here is how to write an update statement.

https://www.w3schools.com/sql/sql_update.asp

Sorry I wasn't paying attention because you assured me the code was working but only updating one drive. You need to be sure your SQL works.

$tmplt = "UPDATE dbo.NoendDate Set EndDate = '{0}', EndTime = '{1}', EndSpace = '{2}'"

[mtartaglia]

That made some progress. Now all the EndSpace fields in three rows are identical numbers which is impossible since it is looking at different volumes and servers.

[jvierra]

It is likely you are querying the same server repeatedly and that server has only one drive.

Add this line:

Write-Host $_.PsComputerName, $_.DeviceID, $_.Freespace

[mtartaglia]

Yes that is what I show while in the debugger with a breakpoint.

I think if I query on the ID field (auto incremented field) in the view, I may be able to use a where command in the sql statement.

[jvierra]

Yes that is what I show while in the debugger with a breakpoint.

I think if I query on the ID field (auto incremented field) in the view, I may be able to use a where command in the sql statement.

No idea what you are asking. You cannot use an ID in an update except in a where clause.

What is what you show in the debugger?

You update statement will always update all records. You need to sit down and determine what it is you are trying to accomplish then run code at a prompt to test you ideas. We cannot decode what your purpose is or tell you how to accomplish it.

If you are trying to update the "start" records then you need to figure out some way to key the records. This comes under the heading of database design. Perhaps you can find a DBA in your company to help you with the database parts.