Mike Kanakos

Hi Wena,

I think you may be talking about Credential Manager in GUI. This is different than credential mgr and the secrets saved through this module wont appear in the Credential Mgr in the Windows GUI. 

Hi David. Yes searching for the module can be problematic. Use the syntax I included in the article.

The syntax below finds a match when I search by specific name from PS7

$params = @{
    Name              = 'Microsoft.PowerShell.SecretManagement'
    AllowPreRelease   = $true
    Repository        = 'PSGallery'
}
Find-Module @Params

Hi Mike, 

I saw the github issue you opened. Thank you for reaching out. I am going to paste my response I left on github here as well. 
 

so let's go through the question together…. for those unfamilar with the issue Mike raised. you can look here:
https://github.com/compwiz32/PowerShell/issues/7
 

I believe lines 115-124 should be inside of the foreach loop bound by lines 111-113

 If ($null -ne $NestedQueryResult) {
                    foreach ($SubGrp in $NestedQueryResult) {
                        $SubGrpLookup = Get-ADGroup -Identity "$($SubGrp.DistinguishedName)" -Properties Members, CanonicalName -Server $Server
                    }

                    $SubNestedGroupInfo = [PSCustomObject]@{
                        'ParentGroup'            = $NestedADGrp.Name
                        'NestedGroup'            = $SubGrp.Name
                        'NestedGroupMemberCount' = $SubGrpLookup.Members.count
                        'ObjectClass'            = $SubGrp.ObjectClass
                        'ObjectPath'             = $SubGrpLookup.CanonicalName
                        'DistinguishedName'      = $SubGrpLookup.DistinguishedName
                    } #end PSCustomObject

                    $SubNestedGroupInfo
                }

I am sorry the line numbers dont line up, but i copied lines 110-125 here….

this IF loop is only used if there is a nested group found in the earlier lookup…

• it says IF NOT NULL then continue…
• then it says foreach group in $nestedqueryresult > do the $subgrouplookup
• then we create an pscustomobject
• then we return the object
  … and then it goes back through the foreach if there are more nestedgroups in $nestedqueryresult

if I move object inside the foreach, then the next time the loop runs, it will overwrite the first result (if there are more than one).

PowerShell keeps track of the pscustomobject for me. When I come through the second time, it adds to the existing results on output. It took me a long time to understand that logic, but that's Powershell stepping in and doing the work for me … the next run of the loop ADDS to $SubNestedGroupInfo – it doesn’t overwrite it. 

does that make sense?

Vishal,
 

There are plenty of article (probably some on this site) that discuss connecting to SQL. Connecting to a SQL instance is also not hard but outside the scope of the original article and not something I am going to comment on here. 

Saving the data to a file is an easy task. Look at export-csv or out-file cmdlets. Leos' examples are exactly correct. if you need help with saving data, then you need to be more specific. However, we are far from a relevant discussion that relates to this article. 

I am sorry Vishal. I am not sure how to make a connection to a SQL database. 

Turil,

I believe your getting this error because your running a constrained language mode session. I may be wrong but this article is a useful for troubleshooting

https://community.spiceworks.com/topic/1451109-srp-whitelist-causing-odd-behavior-in-powershell-v5

Hi Dexter…. Let me see if I can answer your question… 

Are you asking… How do I run this function for one user ?
Are you asking… How can I make the function prompt for a username to enter?

The default parameter of the function is username and it is a required parameter. If you run the function with no input, it will require you to enter a username… 

Take a look at the link below… I ran the function with no input and it prompts me for a username.

Screencap