Guest User

Untitled

a guest
Feb 5th, 2019
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.59 KB | None | 0 0
  1. $SQLServer = "bla";
  2. $SQLDBName = "bla";
  3. $uid ="bla";
  4. $pwd = "HIdden_Password";
  5.  
  6. $App="com.android.app";
  7.  
  8. $SqlQuery = "SELECT value
  9. FROM obj_user u
  10. JOIN obj_user_device d ON d.id_user = u.id_user
  11. JOIN obj_device od ON od.id_device = d.id_device
  12. JOIN def_device_hardware dh ON dh.id_device_hardware = od.id_device_hardware
  13. JOIN def_device_os do ON do.id_device_os = od.id_device_os
  14. JOIN obj_user_device_app_state das ON das.id_user_device = d.id_user_device
  15. LEFT JOIN obj_device_setting ods ON ods.id_device = od.id_device
  16. LEFT JOIN obj_user_setting ous ON ous.id_user = d.id_user
  17. AND das.bundle_id = '$App'";
  18.  
  19. Write("Number of results from query:")
  20.  
  21. $SqlConnection = New-Object System.Data.SqlClient.SqlConnection
  22. $SqlConnection.ConnectionString = "Server = $SQLServer; Database = $SQLDBName; Integrated Security = True; User ID = $uid; Password = $pwd;"
  23. $SqlCmd = New-Object System.Data.SqlClient.SqlCommand
  24. $SqlCmd.CommandText = $SqlQuery
  25. $SqlCmd.Connection = $SqlConnection
  26. $SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
  27. $SqlAdapter.SelectCommand = $SqlCmd
  28. $DataSet = New-Object System.Data.DataSet
  29. $SqlAdapter.Fill($DataSet)
  30. $rowCount = $SqlAdapter.Fill($DataSet)
  31.  
  32. $DataSet.Tables[0]
  33.  
  34. foreach ($row in $Dataset.tables[0].rows)
  35. {
  36. Write ("entry $row.value")
  37. }
  38.  
  39. Number of results from query:
  40. 2
  41.  
  42. value
  43. -----
  44. **3a5b220714243811**
  45. 105986685869347611614
  46. 3a5b220714243811
  47. **105986685869347611614**
  48.  
  49. entry 3a5b220714243811
  50. **entry 105986685869347611614**
  51. **entry 3a5b220714243811**
  52. entry 105986685869347611614
  53.  
  54. $DataSet.Tables[0] | out-file "File.txt";
Add Comment
Please, Sign In to add comment