@mkanakos
Mike Kanakos commented on
Export and import to and from Excel with the PowerShell module ImportExcel 2 weeks, 2 days agoHi Ripp…
I am not 100% sure. The author of exportExcel has a wonderful website with many examples. You can check there or ask him directly.
I found relevant pages on the web that shows some examples but didn;t work all people in all cases.
Example1:
https://github.com/dfinke/ImportExcel/issues/118Example2:
Export-Excel (from ImportExcel module) is swallowing my decimal and date points…
byu/germanyjr112 inPowerShellwhat you will see when you read those posts is essentially that the data needs to be formatting before its exported.
-
Mike Kanakos commented on
Export and import to and from Excel with the PowerShell module ImportExcel 2 weeks, 2 days agoThe -importcolumns parameter requires the -worksheet parameter also. Since you didn’t specify a worksheetname, it doesn’t know which tab to pull the column data from.
-
The code i wrote is a function which means you have to load it into memory first or add it to your profile so it is autoloaded when you start your powershell prompt.
to load the function:
[powershell]. (path to file)backup-grouppolicy.ps1 [/powershell]
Notice the extra dot in the front of the line. You can also lookup dot-sourcing for a full explainer.then the cmdlet Backup-GroupPolicy will be avilable to use like any other cmdlet.
-
Mike Kanakos commented on
Get AD user group membership with Get-ADPrincipalGroupMembership 1 year, 1 month agoNice screenshots ! …wink, wink..
-
Mike Kanakos's profile was updated 1 year, 3 months ago
-
Mike Kanakos's profile was updated 1 year, 3 months ago
-
Mike Kanakos commented on
SecretsManagement module for PowerShell: Save passwords in PowerShell 1 year, 3 months agoCameron,
I ended up writing extensively about customizing your PowerShell command prompt at my site. The reason for this is that the post is very detailed and longer than the posts we usually do on 4sysops. If you would like to know more check out my article here:
https://www.commandline.ninja/customize-pscmdprompt/ -
Mike Kanakos commented on
PowerShell script to display information about Active Directory users 1 year, 3 months agoHi Gokul,
The tool in this article does not accept pipeline input because i did not include the parameter to do so. This required to be able to pass a list to the function. Take a look at my website https://www.commandline.ninja . I'll write up a newer version of this tool on my site this week.
-
Mike Kanakos's profile was updated 1 year, 5 months ago
-
Mike Kanakos wrote a new post,
Export and import to and from Excel with the PowerShell module ImportExcel 1 year, 5 months agoThe ImportExcel is a PowerShell module that allows you import to or export data directly from Excel spreadsheets without having Microsoft Excel installed on your computer. In this tutorial, you’ll learn to work with Import-Excel and Export-Excel. The ImportExcel module runs on Windows, Linux, or Mac and now can be used in Azure functions and GitHub Actions. Simply put, if you need to generate reports for work, you must learn this module.
-
Mike Kanakos's profile was updated 1 year, 7 months ago
Pablo Brincat and
Mike Kanakos are now friends 1 year, 7 months ago-
Mike Kanakos wrote a new post,
Getting started with the PSReadLine module for PowerShell 1 year, 7 months agoPSReadLine is a module created by Microsoft to customize the command line editing environment in PowerShell. It offers numerous customizations that can change how your command line editor presents data in many ways.
-
Hi CB
You can add HTML to the body of the email and embed a logo. I’ll see if I can find a working example for you.
-
Hi Kevin,
I too still use Send-mailmessage. There is a .net alternative but i need to do some research into that before i can share how to use that code.
-
Mike Kanakos liked the comment of Dave on A password expiration reminder script in PowerShell. (So far, Dave has 2 likes for this comment) 2 years, 3 months ago
-
Mike Kanakos liked the comment of Manukumar K M on Invoke-Command: Connecting to computers requiring different credentials. (So far, Manukumar K M has 1 likes for this comment) 2 years, 4 months ago
-
I don't think I quite understand your setup, so more info is needed but ultimately your issue may be past the scope of this forum.
- If you have your printers setup to use print queues from network servers, then the printers are not available to print if the print queues are not online.
- If you are saying that your DC is down, well…. that's a bigger problem.
Otherwise, the conversation between client and printer should not be reliant on the GPO settings after the printer is configured via GPO.
-
Mike Kanakos commented on
SecretsManagement module for PowerShell: Save passwords in PowerShell 2 years, 5 months agodon't want to prompt user from time to time for the master password.
Hi Sylvia,
This is probably the most common question I get with secrets mgmt.
Short Answer:
Yes! There are options to solve your issue but they come with a serious reduction in securityLong Answer:
You can configure the local vault to have no master password and you can also configure the vault to not be stored in the AllUsers profile instead of inside a specific user profile. Those two settings are not coupled together, meaning you can do one, or the other, or both. However, you are seriously reducing the security when you enable these options.Some extra info to consider…
This solution from Microsoft has an intended use: password mgmt for a user. If you need more options to support things like automating scripts without user interaction, then the long term answer is a 3rd party vault or AZ KeyVault, which have better authentication methods.
The SecretStore vault was built to fill a need for users who are struggling managing passwords on their local systems. A cloud based vault will have better options and choices. That is why there are multiple vaults available that work with the SecretManagement module. Pick the right one for the task, instead of trying to bend the SecretStore vault to your needs..
One last point…
There is talk in the community of using a certificate as the AUTH method for a local password vault. This would solve your problem AND ALSO maintain a high level of security but it doesn't exist as of the time of this comment…Hoped that helps!
-
Hi Tiziao,
Group Policy handles getting the printer to appear on your machine. Once that occurs, GPO is not involved in printing anymore except for refreshing the printer on your machine.
Printing works directly between client (computer) and print queue or client (computer) and Printer (direct IP printing) depending on your config.
- Load More
