Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Export user list to CSV (All projects or Current project) #67

Merged
merged 3 commits into from
Jul 25, 2023
Merged

Export user list to CSV (All projects or Current project) #67

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
3 commits
Select commit Hold shift + click to select a range
f57e7cc
Add function to export list of LCS users
ni-bu-gen2 Mar 3, 2022
3e0d8ab
Resolve typo (Current projects -> Current project)
ni-bu-gen2 Mar 3, 2022
b5c0181
Allow disabling of credentials output on word document
ni-bu-gen2 Mar 4, 2022
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Allow disabling of credentials output on word document
  • Loading branch information
@ni-bu-gen2
ni-bu-gen2 committed Mar 4, 2022
commit b5c01814ad202645db5226cbfb5d31a82cfc68ef
6 changes: 6 additions & 0 deletions 2LCS/App.config
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -31,6 +31,12 @@
<setting name="projOrgExcl" serializeAs="String">
<value />
</setting>
<setting name="RDPCredentialsEnabled" serializeAs="String">
<value />
</setting>
<setting name="LocalCredentialsEnabled" serializeAs="String">
<value />
</setting>
<setting name="cachingEnabled" serializeAs="String">
<value>False</value>
</setting>
Expand Down
168 changes: 91 additions & 77 deletions 2LCS/Forms/MainForm.cs
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -917,6 +917,9 @@ private void ExportProjectDataToolStripMenuItem_Click(object sender, EventArgs e
RefreshMenuItem_Click(null, null);
var projectUsers = _httpClientHelper.GetAllProjectUsers();

bool includeRdpEntryPassword = Properties.Settings.Default.RDPCredentialsEnabled;
bool exportCHECredentials = Properties.Settings.Default.LocalCredentialsEnabled;

notifyIcon.BalloonTipText = $"Exporting data for {_selectedProject.Name} project. Please wait...";
notifyIcon.BalloonTipTitle = "Exporting LCS project data";

Expand Down Expand Up @@ -1087,34 +1090,37 @@ private void ExportProjectDataToolStripMenuItem_Click(object sender, EventArgs e
}

instanceHeader.InsertTableAfterSelf(instanceDetailsTable);

var rdpList = _httpClientHelper.GetRdpConnectionDetails(saasInstance);
if (rdpList.Count > 0)
if (includeRdpEntryPassword)
{
var vms = document.InsertParagraph("RDP connections: " + saasInstance.DisplayName.ToUpper()).FontSize(14d);
vms.SpacingBefore(20d);
vms.SpacingAfter(10d);
foreach (var rdpEntry in rdpList)
var rdpList = _httpClientHelper.GetRdpConnectionDetails(saasInstance);
if (rdpList.Count > 0)
{
//RDP details table
var columnWidths = new float[] { 300f, 400f };
var rdpTable = document.AddTable(4, columnWidths.Length);
rdpTable.SetWidths(columnWidths);
rdpTable.Design = TableDesign.LightListAccent1;
rdpTable.Alignment = Alignment.left;
rdpTable.AutoFit = AutoFit.Contents;
rdpTable.Rows[0].Cells[0].Paragraphs[0].Append("Machine name");
rdpTable.Rows[0].Cells[1].Paragraphs[0].Append(rdpEntry.Machine);
rdpTable.Rows[1].Cells[0].Paragraphs[0].Append("RDP address");
rdpTable.Rows[1].Cells[1].Paragraphs[0].Append(rdpEntry.Address + ":" + rdpEntry.Port);
rdpTable.Rows[2].Cells[0].Paragraphs[0].Append("User name");
rdpTable.Rows[2].Cells[1].Paragraphs[0].Append(rdpEntry.Domain + "\\" + rdpEntry.Username);
rdpTable.Rows[3].Cells[0].Paragraphs[0].Append("Password");
rdpTable.Rows[3].Cells[1].Paragraphs[0].Append(rdpEntry.Password);
var vms = document.InsertParagraph("RDP connections: " + saasInstance.DisplayName.ToUpper()).FontSize(14d);
vms.SpacingBefore(20d);
vms.SpacingAfter(10d);
foreach (var rdpEntry in rdpList)
{
//RDP details table
var columnWidths = new float[] { 300f, 400f };
var rdpTable = document.AddTable(4, columnWidths.Length);
rdpTable.SetWidths(columnWidths);
rdpTable.Design = TableDesign.LightListAccent1;
rdpTable.Alignment = Alignment.left;
rdpTable.AutoFit = AutoFit.Contents;
rdpTable.Rows[0].Cells[0].Paragraphs[0].Append("Machine name");
rdpTable.Rows[0].Cells[1].Paragraphs[0].Append(rdpEntry.Machine);
rdpTable.Rows[1].Cells[0].Paragraphs[0].Append("RDP address");
rdpTable.Rows[1].Cells[1].Paragraphs[0].Append(rdpEntry.Address + ":" + rdpEntry.Port);
rdpTable.Rows[2].Cells[0].Paragraphs[0].Append("User name");
rdpTable.Rows[2].Cells[1].Paragraphs[0].Append(rdpEntry.Domain + "\\" + rdpEntry.Username);
rdpTable.Rows[3].Cells[0].Paragraphs[0].Append("Password");
rdpTable.Rows[3].Cells[1].Paragraphs[0].Append(rdpEntry.Password);

document.InsertTable(rdpTable);
document.InsertParagraph();
}
}
}
foreach (var vm in saasInstance.Instances)
{
var CredentialsDict = _httpClientHelper.GetCredentials(saasInstance.EnvironmentId, vm.ItemName);
Expand Down Expand Up @@ -1206,69 +1212,77 @@ private void ExportProjectDataToolStripMenuItem_Click(object sender, EventArgs e
}

instanceHeader.InsertTableAfterSelf(instanceDetailsTable);
var rdpList = _httpClientHelper.GetRdpConnectionDetails(instance);
if (rdpList.Count > 0)
if (includeRdpEntryPassword)
{
var vms = document.InsertParagraph("RDP connections: " + instance.DisplayName.ToUpper()).FontSize(14d);
vms.SpacingBefore(20d);
vms.SpacingAfter(10d);
foreach (var rdpEntry in rdpList)
var rdpList = _httpClientHelper.GetRdpConnectionDetails(instance);
if (rdpList.Count > 0)
{
//RDP details table
var columnWidths = new float[] { 300f, 400f };
var rdpTable = document.AddTable(3, columnWidths.Length);
rdpTable.SetWidths(columnWidths);
rdpTable.Design = TableDesign.LightListAccent1;
rdpTable.Alignment = Alignment.left;
rdpTable.AutoFit = AutoFit.Contents;
rdpTable.Rows[0].Cells[0].Paragraphs[0].Append("RDP address");
rdpTable.Rows[0].Cells[1].Paragraphs[0].Append(rdpEntry.Address + ":" + rdpEntry.Port);
rdpTable.Rows[1].Cells[0].Paragraphs[0].Append("User name");
rdpTable.Rows[1].Cells[1].Paragraphs[0].Append(rdpEntry.Domain + "\\" + rdpEntry.Username);
rdpTable.Rows[2].Cells[0].Paragraphs[0].Append("Password");
rdpTable.Rows[2].Cells[1].Paragraphs[0].Append(rdpEntry.Password);
document.InsertTable(rdpTable);
document.InsertParagraph();
var vms = document.InsertParagraph("RDP connections: " + instance.DisplayName.ToUpper()).FontSize(14d);
vms.SpacingBefore(20d);
vms.SpacingAfter(10d);
foreach (var rdpEntry in rdpList)
{
//RDP details table
var columnWidths = new float[] { 300f, 400f };
var rdpTable = document.AddTable(3, columnWidths.Length);
rdpTable.SetWidths(columnWidths);
rdpTable.Design = TableDesign.LightListAccent1;
rdpTable.Alignment = Alignment.left;
rdpTable.AutoFit = AutoFit.Contents;
rdpTable.Rows[0].Cells[0].Paragraphs[0].Append("RDP address");
rdpTable.Rows[0].Cells[1].Paragraphs[0].Append(rdpEntry.Address + ":" + rdpEntry.Port);
rdpTable.Rows[1].Cells[0].Paragraphs[0].Append("User name");
rdpTable.Rows[1].Cells[1].Paragraphs[0].Append(rdpEntry.Domain + "\\" + rdpEntry.Username);
rdpTable.Rows[2].Cells[0].Paragraphs[0].Append("Password");
rdpTable.Rows[2].Cells[1].Paragraphs[0].Append(rdpEntry.Password);

document.InsertTable(rdpTable);
document.InsertParagraph();
}
}
}
foreach (var vm in instance.Instances)

if (exportCHECredentials)
{
var CredentialsDict = _httpClientHelper.GetCredentials(instance.EnvironmentId, vm.ItemName);
if (CredentialsDict.Count > 0)
foreach (var vm in instance.Instances)
{
var credentialsParagraph = document.InsertParagraph("Credentials").FontSize(14d);
credentialsParagraph.SpacingBefore(20d);
credentialsParagraph.SpacingAfter(10d);
// CHE credentials table
var columnWidths = new float[] { 150f, 150f };
var credentialsTable = document.AddTable(1, columnWidths.Length);
credentialsTable.SetWidths(columnWidths);
credentialsTable.Design = TableDesign.LightListAccent3;
credentialsTable.Alignment = Alignment.left;
credentialsTable.AutoFit = AutoFit.Contents;
credentialsTable.Rows[0].Cells[0].Paragraphs[0].Append("User name");
credentialsTable.Rows[0].Cells[1].Paragraphs[0].Append("Password");

foreach (var credential in CredentialsDict)
var CredentialsDict = _httpClientHelper.GetCredentials(instance.EnvironmentId, vm.ItemName);
if (CredentialsDict.Count > 0)
{
var r = credentialsTable.InsertRow();
r.Cells[0].Paragraphs[0].Append(credential.Key
.Replace("Dev-Local admin-", "")
.Replace("Dev-Local user-", "")
.Replace("Dev-Sql server login-", "")
.Replace("Build-Local user-", "")
.Replace("Build-Sql server login-", "")
.Replace("AOS-Local admin-", "")
.Replace("BI-Local admin-", "")
.Replace("AD-AosServiceUser-", "")
.Replace("AD-SqlServiceUser-", "")
.Replace("AD-DynamicsInstallUser-", "")
.Replace("AD-SPServiceUser-", "")
.Replace("AD-BCProxyUser-", "")
.Replace("AD-Local admin-", ""));
r.Cells[1].Paragraphs[0].Append(credential.Value);
var credentialsParagraph = document.InsertParagraph("Credentials").FontSize(14d);
credentialsParagraph.SpacingBefore(20d);
credentialsParagraph.SpacingAfter(10d);
// CHE credentials table
var columnWidths = new float[] { 150f, 150f };
var credentialsTable = document.AddTable(1, columnWidths.Length);
credentialsTable.SetWidths(columnWidths);
credentialsTable.Design = TableDesign.LightListAccent3;
credentialsTable.Alignment = Alignment.left;
credentialsTable.AutoFit = AutoFit.Contents;
credentialsTable.Rows[0].Cells[0].Paragraphs[0].Append("User name");
credentialsTable.Rows[0].Cells[1].Paragraphs[0].Append("Password");

foreach (var credential in CredentialsDict)
{
var r = credentialsTable.InsertRow();
r.Cells[0].Paragraphs[0].Append(credential.Key
.Replace("Dev-Local admin-", "")
.Replace("Dev-Local user-", "")
.Replace("Dev-Sql server login-", "")
.Replace("Build-Local user-", "")
.Replace("Build-Sql server login-", "")
.Replace("AOS-Local admin-", "")
.Replace("BI-Local admin-", "")
.Replace("AD-AosServiceUser-", "")
.Replace("AD-SqlServiceUser-", "")
.Replace("AD-DynamicsInstallUser-", "")
.Replace("AD-SPServiceUser-", "")
.Replace("AD-BCProxyUser-", "")
.Replace("AD-Local admin-", ""));
r.Cells[1].Paragraphs[0].Append(credential.Value);
}
credentialsParagraph.InsertTableAfterSelf(credentialsTable).InsertPageBreakAfterSelf();
}
credentialsParagraph.InsertTableAfterSelf(credentialsTable).InsertPageBreakAfterSelf();
}
}
}
Expand Down
Loading