I'm trying to send data through e-mail but when I add variables for the data, I'm getting System.Data.DataRow instead of the data that I want in there. I'm pulling from a database using PowerGadgets snap-in and sending e-mail with the PSCX snap-in
Here's my code so far:
<br />
Add-PSSnapin PSCX<br />
Add-PSSnapin PowerGadgets</span></p>
<p><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">$eSMTPServer = "server ip"<br />
$eFrom = "emailaddress"<br />
$eTo = "myemailaddress"<br />
$eSubject = "subject"</span></p>
<p><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">$ADemail = invoke-sql -server 'server' -database 'db' -sql "select ea.Mail from tblEmailaccounts ea inner join tblUsers us on ea.displayname = us.displayname inner join tblPINCodes pc on ea.displayname = pc.displayname order by us.displayname, ea.displayname, pc.displayname"<br />
$ADemail|Export-Csv "C:\Scripts\Email2.csv"<br />
$user = invoke-sql -server 'server' -database 'db' -sql "select pc.FirstName from tblEmailaccounts ea inner join tblUsers us on ea.displayname = us.displayname inner join tblPINCodes pc on ea.displayname = pc.displayname where pc.displayname = 'valdez, dustinn' order by us.displayname, ea.displayname, pc.displayname"<br />
#$user |Export-Csv "C:\Scripts\Names2.csv"<br />
$PIN = invoke-sql -server 'server' -database 'db' -sql "select pc.PIN from tblEmailaccounts ea inner join tblUsers us on ea.displayname = us.displayname inner join tblPINCodes pc on ea.displayname = pc.displayname where pc.displayname = 'valdez, dustinn' order by us.displayname, ea.displayname, pc.displayname" <br />
$PIN<br />
$message = "Hello $user, your PIN code is $PIN. </span></p>
<p><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><br />
Send-SmtpMail -Subject $eSubject -To $eTo -From $eFrom -SmtpHost $eSMTPServer -Body $message;<br />
Any help is appreciated, thanks!