Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $SQLServer = "bla";
- $SQLDBName = "bla";
- $uid ="bla";
- $pwd = "HIdden_Password";
- $App="com.android.app";
- $SqlQuery = "SELECT value
- FROM obj_user u
- JOIN obj_user_device d ON d.id_user = u.id_user
- JOIN obj_device od ON od.id_device = d.id_device
- JOIN def_device_hardware dh ON dh.id_device_hardware = od.id_device_hardware
- JOIN def_device_os do ON do.id_device_os = od.id_device_os
- JOIN obj_user_device_app_state das ON das.id_user_device = d.id_user_device
- LEFT JOIN obj_device_setting ods ON ods.id_device = od.id_device
- LEFT JOIN obj_user_setting ous ON ous.id_user = d.id_user
- AND das.bundle_id = '$App'";
- Write("Number of results from query:")
- $SqlConnection = New-Object System.Data.SqlClient.SqlConnection
- $SqlConnection.ConnectionString = "Server = $SQLServer; Database = $SQLDBName; Integrated Security = True; User ID = $uid; Password = $pwd;"
- $SqlCmd = New-Object System.Data.SqlClient.SqlCommand
- $SqlCmd.CommandText = $SqlQuery
- $SqlCmd.Connection = $SqlConnection
- $SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
- $SqlAdapter.SelectCommand = $SqlCmd
- $DataSet = New-Object System.Data.DataSet
- $SqlAdapter.Fill($DataSet)
- $rowCount = $SqlAdapter.Fill($DataSet)
- $DataSet.Tables[0]
- foreach ($row in $Dataset.tables[0].rows)
- {
- Write ("entry $row.value")
- }
- Number of results from query:
- 2
- value
- -----
- **3a5b220714243811**
- 105986685869347611614
- 3a5b220714243811
- **105986685869347611614**
- entry 3a5b220714243811
- **entry 105986685869347611614**
- **entry 3a5b220714243811**
- entry 105986685869347611614
- $DataSet.Tables[0] | out-file "File.txt";
Add Comment
Please, Sign In to add comment