Monday Help

Background:
Backup Exec version 20.0 1188.1863
Exchange2010

Issues
Full Backup file Fail w/ the following messages:
---------------------------------------------------------
The consistency check of the snapshot for the Microsoft Exchange database Database was successful.
Monday, May 20, 2019 9:37:17 AM - V-79-57344-65247 - A failure occurred reading an object.

Monday, May 20, 2019 9:37:18 AM - WARNING: "\\concor-ex.XXXdomain.net\Microsoft Information Store\Mailbox Database 1\Database" is a corrupt file. This file cannot verify.
The consistency check of the snapshot for the Microsoft Exchange transaction log Logs ( E0000803337.log - E00008037B8.log ) has failed. You should check for possible data corruption in the transaction log that is online.
-------------------------------------------------------

The Exchange seems running ok but can't backup

What is the issue with the exchange transaction log?
How can I solve it?

7 Comments

SQL View to group employees and show days for range.
I have my SQL View which is showing me the data that I want however it is not formatting how I would want it and I am at a brick wall with it -

Here is my sql

SELECT DISTINCT 
                          dbo.EMPLOYEELIST.EMPLOYEE_NAME,
                        
						 dbo.EMPLOYEELIST.ACTIVE, 
						 CASE WHEN cast(dbo.TimeEntered.Monday  as time) = '00:00:00.0000000' then NULL
						 WHEN cast(dbo.TimeEntered.Monday  as time) <> '00:00:00.0000000' then cast(dbo.TimeEntered.Monday  as date)
						 END AS MONDAY,
						  CASE WHEN cast(dbo.TimeEntered.Tuesday  as time) = '00:00:00.0000000' then NULL
						 WHEN cast(dbo.TimeEntered.Tuesday  as time) <> '00:00:00.0000000' then cast(dbo.TimeEntered.Tuesday  as date)
						 END AS Tuesday,
						 	  CASE WHEN cast(dbo.TimeEntered.Wed  as time) = '00:00:00.0000000' then NULL
						 WHEN cast(dbo.TimeEntered.Wed  as time) <> '00:00:00.0000000' then cast(dbo.TimeEntered.Wed  as date)
						 END AS Wednesday,
						 	 	  CASE WHEN cast(dbo.TimeEntered.Thursday  as time) = '00:00:00.0000000' then NULL
						 WHEN cast(dbo.TimeEntered.Thursday  as time) <> '00:00:00.0000000' then cast(dbo.TimeEntered.Thursday  as date)
						 END AS Thursday,
						 	 	 	  CASE WHEN cast(dbo.TimeEntered.Friday  as time) = '00:00:00.0000000' then NULL
						 WHEN cast(dbo.TimeEntered.Friday  as time) <> '00:00:00.0000000' then cast(dbo.TimeEntered.Friday  as date)
						 END AS Friday,

Open in new window

…

22 Comments

Good morning all,

So I have a new issue, Shocker with it being a Monday Morning and all. I've been told that I need to change site codes for a number of OU's and change the associated groups which reside either in that OU or somewhere else.

Now

I need to change only the site part of the group, i'm kind of debating deleting and recreating the groups however in the (Likely) event that I'll need to do this again I'm trying to make it self contained.

$OUs = Read-Host "Please enter the OU and Associated groups you'd like to change"

$NewOU = Read-Host "Please enter the new name of the OU and groups"

Foreach ($OU in $OUs){
Get-ADOrganizationalUnit -filter "Name -like $ou" | Set-ADOrganizationalUnit -DisplayName $NewOU }

Get-ADGroup -filter "Name -like $ou"

Open in new window

This is where I've got to and it's pretty shocking, maybe because I broke myself on Friday night and I've still got a headache.

Any hints on how I can do this would be great. I'm still trying to learn the intricacies of PowerShell so please advise rather than giving the straight answer :D

I don't think this is a hash group thing either.

Thanks
ALex

3 Comments

I want to add a conditional formatting to the cells in column G ( 7 - 22) . I want the cells to highlight a certain color blue (RGB 183, 222, 232) if the ship date in column H is delinquent based on today's date OR if the ship date carries through to Sunday of that week. For example today is Monday, Sept 10th. The cells in column G should highlight if the ship date is through Sunday, Sept 16th.

Second, is it possible to also to write a formula in cell H31 to automatically sum up all cells that are highlighted in the blue in column G so that I don't have to manually do the sum each time I move lines around?

Third, is it possible to also to write a formula in cell H32 to automatically sum up all cells that are highlighted in the purple (RGB 204, 192, 218) in column K so that I don't have to manually do the sum each time I move lines around?

Fourth, is it possible to write a formula in cell G32 to automatically sum up all cells that are highlighted in the green (RGB 0, 255, 0) in column K so that I don't have to manually do the sum each time I move lines around?
FCS-TRAINING.xlsx

11 Comments

Hi Experts,
I had asked a question about First Monday & Third Monday of the week couple week ago and Expert Gustav Brock gave me the Public Function which works but when I tried to place to another form, it does not work as it suppose. I know I did something wrong, but did not what I miss. below is my code on a datefield:
Private Sub PDFIRSTCRTDATE_Exit(Cancel As Integer)
Dim DateInMonth As Date
DateInMonth = Date

If Me.HoldCalA = "Cal 24" Or Me.HoldCalA = "Cal 42" Or Me.HoldCalA = "Cal 54" Then
If Me.PDFIRSTCRTDATE = DateWeekdayInMonth(DateInMonth, 1, vbMonday) Or Me.PDFIRSTCRTDATE = DateWeekdayInMonth(DateInMonth, 3, vbMonday) Then
Else
MsgBox "You have schedule on the wrong Monday for the " & Me.HoldCalA & "."
End If
End If
End Sub

Here is the Public Function from Gustav Brock:
' Calculates the date of the occurrence of Weekday in the month of DateInMonth.
'
' If Occurrence is 0 or negative, the first occurrence of Weekday in the month is assumed.
' If Occurrence is 5 or larger, the last occurrence of Weekday in the month is assumed.
'
' If Weekday is invalid or not specified, the weekday of DateInMonth is used.
'
' 2016-06-09. Gustav Brock, Cactus Data ApS, CPH.
'
Public Function DateWeekdayInMonth( _
ByVal DateInMonth As Date, _
Optional ByVal Occurrence As Integer, _
Optional ByVal Weekday As VbDayOfWeek = -1) _
As Date

Const DaysInWeek As Integer = 7

…

8 Comments

Monday

Related Topics

Monday

Related Topics