public void Execute(IJobExecutionContext context)
{
try
{
using (CloudPanelDbContext db = new CloudPanelDbContext(Config.ServiceSettings.SqlConnectionString))
{
using (ExchActions powershell = new ExchActions())
{
List<StatMailboxDatabaseSizes> mailboxDatabases = powershell.Get_MailboxDatabaseSizes();
db.StatMailboxDatabaseSizes.InsertAllOnSubmit(mailboxDatabases);
db.SubmitChanges();
}
}
}
catch (Exception ex)
{
CPService.LogError("Failed to retrieve mailbox database sizes: " + ex.ToString());
}
}
public void Execute(IJobExecutionContext context)
{
try
{
using (CloudPanelDbContext db = new CloudPanelDbContext(Config.ServiceSettings.SqlConnectionString))
{
using (ExchActions powershell = new ExchActions())
{
List <StatMailboxDatabaseSizes> mailboxDatabases = powershell.Get_MailboxDatabaseSizes();
db.StatMailboxDatabaseSizes.InsertAllOnSubmit(mailboxDatabases);
db.SubmitChanges();
}
}
}
catch (Exception ex)
{
CPService.LogError("Failed to retrieve mailbox database sizes: " + ex.ToString());
}
}
public void Execute(IJobExecutionContext context)
{
if (Config.ServiceSettings.ExchangeVersion > 2010)
{
try
{
using (CloudPanelDbContext db = new CloudPanelDbContext(Config.ServiceSettings.SqlConnectionString))
{
// Find users with missing Exchange Guid that are Exchange enabled
IEnumerable<Users> users = db.Users.Where(x => x.MailboxPlan > 0).Where(x => x.ExchangeGuid == Guid.Empty);
if (users != null)
{
using (ExchActions exchTasks = new ExchActions())
{
foreach (Users user in users)
{
try
{
Guid exchangeGuid = exchTasks.Get_ExchangeGuid(user.UserPrincipalName);
user.ExchangeGuid = exchangeGuid;
}
catch (Exception ex)
{
CPService.LogError("Error retrieving Exchange GUID for " + user.UserPrincipalName + ": " + ex.ToString());
}
}
db.SubmitChanges();
}
}
}
}
catch (Exception ex)
{
CPService.LogError("Error finding missing ExchangeGuid values: " + ex.ToString());
}
}
}
public void Execute(IJobExecutionContext context)
{
int processedCount = 0, failedCount = 0;
try
{
using (ExchActions powershell = new ExchActions())
{
// Our timestamps to look for
DateTime startTime = DateTime.Now.AddHours(-24);
DateTime endTime = DateTime.Now;
// Get the sent and received logs for the past 24 hours from Exchange
List<MessageTrackingLog> sentLogs = powershell.Get_TotalSentMessages(startTime, endTime);
List<MessageTrackingLog> receivedLogs = powershell.Get_TotalReceivedMessages(startTime, endTime);
// Initialize our database
using (CloudPanelDbContext db = new CloudPanelDbContext(Config.ServiceSettings.SqlConnectionString))
{
// Find a list of ALL mailbox users
IQueryable<Users> allMailboxes = db.Users.Where(x => x.MailboxPlan > 0);
// Look through each mailbox adding the message tracking information
foreach (Users user in allMailboxes)
{
try
{
IEnumerable<MessageTrackingLog> totalSentLogs = sentLogs.Where(a => a.Users.Contains(user.Email, StringComparer.OrdinalIgnoreCase));
IEnumerable<MessageTrackingLog> totalReceivedLogs = receivedLogs.Where(a => a.Users.Contains(user.Email, StringComparer.OrdinalIgnoreCase));
int totalSentLogsCount = totalSentLogs.Count();
int totalReceivedLogsCount = totalReceivedLogs.Count();
StatMessageTrackingCounts newCount = new StatMessageTrackingCounts();
newCount.UserID = user.ID;
newCount.Start = startTime;
newCount.End = endTime;
newCount.TotalSent = totalSentLogsCount;
newCount.TotalReceived = totalReceivedLogsCount;
newCount.TotalBytesSent = totalSentLogsCount > 0 ? totalSentLogs.Select(a => a.TotalBytes).Sum() : 0;
newCount.TotalBytesReceived = totalReceivedLogsCount > 0 ? totalReceivedLogs.Select(a => a.TotalBytes).Sum() : 0;
db.StatMessageTrackingCounts.InsertOnSubmit(newCount);
processedCount++;
}
catch (Exception ex)
{
CPService.LogError("Error getting total messages for " + user.Email + ": " + ex.ToString());
failedCount++;
}
}
// Save to database
db.SubmitChanges();
}
}
}
catch (Exception ex)
{
CPService.LogError("Failed to retrieve message logs: {0}: " + ex.ToString());
}
}
public void Execute(IJobExecutionContext context)
{
int processedCount = 0, failedCount = 0;
try
{
using (ExchActions powershell = new ExchActions())
{
// Our timestamps to look for
DateTime startTime = DateTime.Now.AddHours(-24);
DateTime endTime = DateTime.Now;
// Get the sent and received logs for the past 24 hours from Exchange
List <MessageTrackingLog> sentLogs = powershell.Get_TotalSentMessages(startTime, endTime);
List <MessageTrackingLog> receivedLogs = powershell.Get_TotalReceivedMessages(startTime, endTime);
// Initialize our database
using (CloudPanelDbContext db = new CloudPanelDbContext(Config.ServiceSettings.SqlConnectionString))
{
// Find a list of ALL mailbox users
IQueryable <Users> allMailboxes = db.Users.Where(x => x.MailboxPlan > 0);
// Look through each mailbox adding the message tracking information
foreach (Users user in allMailboxes)
{
try
{
IEnumerable <MessageTrackingLog> totalSentLogs = sentLogs.Where(a => a.Users.Contains(user.Email, StringComparer.OrdinalIgnoreCase));
IEnumerable <MessageTrackingLog> totalReceivedLogs = receivedLogs.Where(a => a.Users.Contains(user.Email, StringComparer.OrdinalIgnoreCase));
int totalSentLogsCount = totalSentLogs.Count();
int totalReceivedLogsCount = totalReceivedLogs.Count();
StatMessageTrackingCounts newCount = new StatMessageTrackingCounts();
newCount.UserID = user.ID;
newCount.Start = startTime;
newCount.End = endTime;
newCount.TotalSent = totalSentLogsCount;
newCount.TotalReceived = totalReceivedLogsCount;
newCount.TotalBytesSent = totalSentLogsCount > 0 ? totalSentLogs.Select(a => a.TotalBytes).Sum() : 0;
newCount.TotalBytesReceived = totalReceivedLogsCount > 0 ? totalReceivedLogs.Select(a => a.TotalBytes).Sum() : 0;
db.StatMessageTrackingCounts.InsertOnSubmit(newCount);
processedCount++;
}
catch (Exception ex)
{
CPService.LogError("Error getting total messages for " + user.Email + ": " + ex.ToString());
failedCount++;
}
}
// Save to database
db.SubmitChanges();
}
}
}
catch (Exception ex)
{
CPService.LogError("Failed to retrieve message logs: {0}: " + ex.ToString());
}
}
public void Execute(IJobExecutionContext context)
{
try
{
using (CloudPanelDbContext db = new CloudPanelDbContext(Config.ServiceSettings.SqlConnectionString))
{
// Get a list of all users with mailboxes
IEnumerable<Users> mailboxes = db.Users.Where(x => x.MailboxPlan > 0);
IEnumerable<Users> archives = mailboxes.Where(x => x.ArchivePlan > 0);
if (mailboxes != null)
{
using (ExchActions powershell = new ExchActions())
{
// Process mailbox sizes
foreach (Users user in mailboxes)
{
try
{
StatMailboxSizes size = powershell.Get_MailboxSize(user.UserGuid, false);
size.UserGuid = user.UserGuid;
size.UserPrincipalName = user.UserPrincipalName;
db.StatMailboxSizes.InsertOnSubmit(size);
}
catch (Exception ex)
{
CPService.LogError("Error getting mailbox size for " + user.UserPrincipalName + ": " + ex.ToString());
}
}
// Process archive sizes
foreach (Users user in archives)
{
try
{
StatMailboxSizes size = powershell.Get_MailboxSize(user.UserGuid, true);
size.UserGuid = user.UserGuid;
size.UserPrincipalName = user.UserPrincipalName;
db.StatMailboxArchiveSizes.InsertOnSubmit(new StatMailboxArchiveSizes()
{
UserGuid = size.UserGuid,
UserPrincipalName = size.UserPrincipalName,
MailboxDatabase = size.MailboxDatabase,
TotalItemSize = size.TotalItemSize,
TotalItemSizeInBytes = size.TotalItemSizeInBytes,
TotalDeletedItemSize = size.TotalDeletedItemSize,
TotalDeletedItemSizeInBytes = size.TotalDeletedItemSizeInBytes,
ItemCount = size.ItemCount,
DeletedItemCount = size.DeletedItemCount,
Retrieved = size.Retrieved
});
}
catch (Exception ex)
{
CPService.LogError("Error getting archive mailbox size for " + user.UserPrincipalName + ": " + ex.ToString());
}
}
// Save the database changes now
db.SubmitChanges();
}
}
}
}
catch (Exception ex)
{
CPService.LogError("Failed to retrieve mailbox and archive sizes: " + ex.ToString());
}
}
public void Execute(IJobExecutionContext context)
{
try
{
using (CloudPanelDbContext db = new CloudPanelDbContext(Config.ServiceSettings.SqlConnectionString))
{
// Get a list of all users with mailboxes
IEnumerable <Users> mailboxes = db.Users.Where(x => x.MailboxPlan > 0);
IEnumerable <Users> archives = mailboxes.Where(x => x.ArchivePlan > 0);
if (mailboxes != null)
{
using (ExchActions powershell = new ExchActions())
{
// Process mailbox sizes
foreach (Users user in mailboxes)
{
try
{
StatMailboxSizes size = powershell.Get_MailboxSize(user.UserGuid, false);
size.UserGuid = user.UserGuid;
size.UserPrincipalName = user.UserPrincipalName;
db.StatMailboxSizes.InsertOnSubmit(size);
}
catch (Exception ex)
{
CPService.LogError("Error getting mailbox size for " + user.UserPrincipalName + ": " + ex.ToString());
}
}
// Process archive sizes
foreach (Users user in archives)
{
try
{
StatMailboxSizes size = powershell.Get_MailboxSize(user.UserGuid, true);
size.UserGuid = user.UserGuid;
size.UserPrincipalName = user.UserPrincipalName;
db.StatMailboxArchiveSizes.InsertOnSubmit(new StatMailboxArchiveSizes()
{
UserGuid = size.UserGuid,
UserPrincipalName = size.UserPrincipalName,
MailboxDatabase = size.MailboxDatabase,
TotalItemSize = size.TotalItemSize,
TotalItemSizeInBytes = size.TotalItemSizeInBytes,
TotalDeletedItemSize = size.TotalDeletedItemSize,
TotalDeletedItemSizeInBytes = size.TotalDeletedItemSizeInBytes,
ItemCount = size.ItemCount,
DeletedItemCount = size.DeletedItemCount,
Retrieved = size.Retrieved
});
}
catch (Exception ex)
{
CPService.LogError("Error getting archive mailbox size for " + user.UserPrincipalName + ": " + ex.ToString());
}
}
// Save the database changes now
db.SubmitChanges();
}
}
}
}
catch (Exception ex)
{
CPService.LogError("Failed to retrieve mailbox and archive sizes: " + ex.ToString());
}
}
