Right click the query result and choose “Save result as” to save the result into a CSV file, then you can open the CSV file in Excel and you can also convert it to .xlsx file.

Normally I would just convert it by creating a custom PS Object and adding each entry since I would have each of the attributes in the object, then create a new PSObject using that. No big deal. …

DECLARE @SQL NVARCHAR (4000) SET @SQL = 'BCP "SELECT COALESCE (CHAR (34)+URN,CHAR …

Jun 13, 2012 · I dont thing we can convert existing OU to container however there are default containers like Users,Computers or create new constainers from ADSIedit where you can move the AD object …

Apr 22, 2015 · One more thing we need to keep in mind is that the registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel\TypeGuessRows only …

They are executed against the back end and are NOT case sensitive. PowerShell filters are executed against the retuned data and, in the case of ADSI objects may be cse sensitive. 'employeeid' seems …

I have a csv file with 200 contacts. This is hybrid environment and contacts are synced to O365. csv file format is: contact contact1.domain.com contact2.domain2.com I need to know if these contacts …

How do you skip x number of lines in a csv file using Powershell? I'm using Power shell v2. Thank you all in advance Monday, November 23, 2015 4:48 AM

Jan 12, 2015 · Is there a best practice on the SAN optimization of LUNs for CSV VHDX files - e.g. sequential vs. random access? We recently set up a small two-node Hyper-V 2012 R2 Failover …

The logic is essentially: For each UPN in list, get all licenses, if one of the licenses is XYZ then write "XYZ" to the appropriate column in CSV for that UPN. Once I figure out how to do this I plan on using …