Hi guys,
I am trying to create a simple script that produces the server names and last backup data for a particular SQL database.
what i have got to far is:
foreach ($sql in get-Content "servers.txt")
{ $srv = get-sqlserver $sql 
   $srvname = $srv.Name 
   $db = get-sqldatabase $srvname test 
   $dbprop = $db.Properties | Where-Object {$_.name -eq 'lastbackupdate'} |Select-Object value
}
I am trying to have the output show the server name and last backup date. At the moment just having trouble trying to see how i can get this output format.
Any help would be appreciated.
regards
DC

$db | select @{name='Server';e={$db.parent.name}}, name, lastbackupdate

Thanks cmille19 thats works great.
I'm wondering if you could explain what is going on in the line you gave me?
I understand some of it but just trying to get a better grasp of it.
thanks
DC

Assigning a database object to the variable $db next we're using the select-object aka select to well, select specific properties of name and lastbackupdate. The Server name is not a property of database class natively, however in PowerShell there are several ways to add synthetic properties to an object. The way we are doing this in the code example above is by using an expression which is abbreviated "e"

The expression @{name='Server';e={$db.parent.name}} creates a new property callled Server, the value is assigned is $db.parent.name. The Parent property of a database object is a server object and the server class has a name property.

I understand it alot better now thanks chad.
I appreciate the help.
Regards
DC