792
Part V: Enterprise Data Management
LISTING 30-4 EmployeeExtract.ps1
#employeeextract.ps1
#This script pulls info from the Person.Contact table in AdventureWorks2012
and presents it to the user$Results = Invoke-Sqlcmd -ServerInstance SQLTWSS\INST01 -Database AdventureWorks2012 -Query "
SELECT TOP 25 [ContactID]
,[FirstName]
,[LastName]
,[EmailAddress]
,[Phone]
FROM [AdventureWorks2012].[Person].[Contact]" | Out-DataTableThe script fi rst connects with the database server and then executes a query. That query
and the connection object are supplied as parameters to the Invoke-SQLCmd cmdlet. The
results are then passed to Out-DataTable and that function converts the results into a
DataTable object. This DataTable is then stored in the $Results variable. Running
this script produces these results:1: Gustavo, Achong, [email protected], 398-555-0132
2: Catherine, Abel, [email protected], 747-555-0171
3: Kim, Abercrombie, [email protected], 334-555-0137
4: Humberto, Acevedo, [email protected], 599-555-0127
5: Pilar, Ackerman, [email protected], 1 (11) 500 555-0132
6: Frances, Adams, [email protected], 991-555-0183
7: Margaret, Smith, [email protected], 959-555-0151
8: Carla, Adams, [email protected], 107-555-0138
9: Jay, Adams, [email protected], 158-555-0142
10: Ronald, Adina, [email protected], 453-555-0165
11: Samuel, Agcaoili, [email protected], 554-555-0110
12: James, Aguilar, [email protected], 1 (11) 500 555-0198
13: Robert, Ahlering, [email protected], 678-555-0175
14: François, Ferrier, franç[email protected], 571-555-0128
15: Kim, Akers, [email protected], 440-555-0166
16: Lili, Alameda, [email protected], 1 (11) 500 555-0150
17: Amy, Alberts, [email protected], 727-555-0115
18: Anna, Albright, [email protected], 197-555-0143
19: Milton, Albury, [email protected], 492-555-0189
20: Paul, Alcorn, [email protected], 331-555-0162
21: Gregory, Alderson, [email protected], 968-555-0153
22: J. Phillip, Alexander, [email protected], 845-555-0187
23: Michelle, Alexander, [email protected], 115-555-0175
24: Sean, Jacobson, [email protected], 555-555-0162
25: Phyllis, Allen, [email protected], 695-555-0111c30.indd 792c30.indd 792 7/31/2012 9:46:23 AM7/31/2012 9:46:23 AM
http://www.it-ebooks.info