Home
- Details
- Written by: Senka
- Category: Exchange Server
- Hits: 1238
$list = Get-Content "dg.txt"
Foreach ($i in $list) {
$i
$grp = get-distributiongroup $i
$manage = $grp.managedby
$newuser = get-user k.tsvetkova
$newmanage = $manage + $newuser
Set-distributiongroup $grp -managedby $newmanage -bypasssecuritygroupmanagercheck
}
Вид файла CSV:
#user,#groupname
#$list = import-csv AddDistributionGroupOwnerList.csv
#Foreach ($i in $list) {
# $grp = get-distributiongroup $i.groupname
# $manage = $grp.managedby
# $newuser = get-user $i.user
# $newmanage = $manage+$newuser
# Set-distributiongroup $grp -managedby $newmanage -bypasssecuritygroupmanagercheck
#}
- Details
- Written by: Senka
- Category: Power Shell
- Hits: 1233
Получаем список членов группы, сравниваем с файлом, где хранится старая информация о составе группе. Если появился новый сотрудник, то отправляем ему письмо.
- Details
- Written by: Senka
- Category: C#
- Hits: 1532
IniFile ini = new IniFile("./config.ini");
if (ini.IniReadValue("Settings", "Server") != "")
servername = ini.IniReadValue("Settings", "Server");
IniFile ini = new IniFile("config.ini");
ini.IniWriteValue("Settings", "Server", servername);
- Details
- Written by: Senka
- Category: C#
- Hits: 1387
openFileDialog1.Filter = "xlsx files (*.xlsx)|*.xlsx|xml files (*.xml)|*.xml|All files (*.*)|*.*";
openFileDialog1.FilterIndex = 1;
if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
textBox1.Text = openFileDialog1.FileName;
// От типа файла запускаем процедуру обработки
switch (openFileDialog1.FilterIndex)
{
case 1: // XLSX
parseXLSX(openFileDialog1.FileName);
break;
case 2: // XML
XmlTextReader reader = new XmlTextReader(openFileDialog1.FileName);
parseXML(reader);
break;
}
}
- Details
- Written by: Senka
- Category: C#
- Hits: 1324
private DataTable openXLSX(string filename)
{
OleDbConnection connection = null;
OleDbCommand command = null;
OleDbDataAdapter adapter = null;
DataSet dataset = new DataSet();
try
{
connection = new OleDbConnection(string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";", filename));
connection.Open();
DataTable sheetsName = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" });
string firstSheetName = sheetsName.Rows[0][2].ToString();
command = new OleDbCommand(string.Format("SELECT * FROM [{0}]",firstSheetName), connection);
//command.CommandType = CommandType.Text;
adapter = new OleDbDataAdapter(command);
adapter.Fill(dataset);
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString());
}
finally
{
if (connection.State == ConnectionState.Open)
connection.Close();
connection.Dispose();
command.Dispose();
adapter.Dispose();
}
return dataset.Tables[0];
}
//dataGridView1.DataSource = dt;
//dataGridView1.Update();