Hi, Every group_cost has different sequence of PP_Seq but it should not be any gap in the sequence of any group_cost rcords. It should always be increment by 1. I want to see any record/row of any group_cost if it has any issue in pp_seq and not increment by 1. I want to see when the issue of sequence is started then it will be corrected with other next rows. 

Create table #Cost (group_cost char(10), PP_Seq int, date1 datetime, ST char(2))

insert into #cost (‘T1′,5,’2023-01-01′,’A’)

insert into #cost (‘T1′,6,’2023-02-01′,’A’)

insert into #cost (‘T1′,7,’2023-03-01′,’A’)

insert into #cost (‘T2′,12,’2023-01-01′,’A’)

insert into #cost (‘T2′,14,’2023-02-01′,’B’)  — This pp_seq is not increment by 1. Should be in output 

insert into #cost (‘T2′,15,’2023-03-01′,’A’)

insert into #cost (‘T3′,25,’2023-01-02′,’A’)

insert into #cost (‘T3′,26,’2023-02-01′,’A’)

insert into #cost (‘T3′,27,’2023-03-05′,’A’)

insert into #cost (‘T5′,65,’2023-01-01′,’A’)

insert into #cost (‘T5′,66,’2023-02-06′,’A’)

insert into #cost (‘T5′,67,’2023-03-04′,’W’)

insert into #cost (‘T5′,69,’2023-04-01′,’A’) — This pp_seq is not increment by 1. Should be in output 

–Expected result

group_cost    PP_Seq      date1                ST        Comments

T2                  14             2023-02-01       B           PP_Seq is not in seq. Also check next rows to correct. 

T5                   69            2023-04-01       A          PP_Seq is not in seq. Also check next rows to correct. 

​Hi, Every group_cost has different sequence of PP_Seq but it should not be any gap in the sequence of any group_cost rcords. It should always be increment by 1. I want to see any record/row of any group_cost if it has any issue in pp_seq and not increment by 1. I want to see when the issue of sequence is started then it will be corrected with other next rows.  Create table #Cost (group_cost char(10), PP_Seq int, date1 datetime, ST char(2))insert into #cost (‘T1′,5,’2023-01-01′,’A’)insert into #cost (‘T1′,6,’2023-02-01′,’A’)insert into #cost (‘T1′,7,’2023-03-01′,’A’) insert into #cost (‘T2′,12,’2023-01-01′,’A’)insert into #cost (‘T2′,14,’2023-02-01′,’B’)  — This pp_seq is not increment by 1. Should be in output insert into #cost (‘T2′,15,’2023-03-01′,’A’) insert into #cost (‘T3′,25,’2023-01-02′,’A’)insert into #cost (‘T3′,26,’2023-02-01′,’A’)insert into #cost (‘T3′,27,’2023-03-05′,’A’) insert into #cost (‘T5′,65,’2023-01-01′,’A’)insert into #cost (‘T5′,66,’2023-02-06′,’A’)insert into #cost (‘T5′,67,’2023-03-04′,’W’)insert into #cost (‘T5′,69,’2023-04-01′,’A’) — This pp_seq is not increment by 1. Should be in output  –Expected resultgroup_cost    PP_Seq      date1                ST        CommentsT2                  14             2023-02-01       B           PP_Seq is not in seq. Also check next rows to correct. T5                   69            2023-04-01       A          PP_Seq is not in seq. Also check next rows to correct.   Read More

​

Could FastTrack assist in the scenario of Transferring an Azure Subscription to a New Microsoft Entra ID

​Could FastTrack assist in the scenario of Transferring an Azure Subscription to a New Microsoft Entra ID  Read More

​

We have a process in SP2016 where one collection has about 200 subsites and another similar collection about 50 subsites. Each subsite is for 1 user, some profile data, and their documents. A couple times a year a group of subsites need to have read access for three other employees (3 different per subsite, not 3 for the group of subsites). After about a month, these permissions are removed. This is a very manual process. This system needs to be converted to SPO, but subsites are not permitted and since the subsite template may change, does not seem appropriate. My process has been to create a record per user, linked to a folder per user and accessed via a PowerApp. I have some workflows to help manage permissions, but it’s not comprehensive yet. I’m interested in finding out how someone else would tackle this migration, keeping in mind that ultimately it is managed by non-tech HR staff. Thank You!

​We have a process in SP2016 where one collection has about 200 subsites and another similar collection about 50 subsites. Each subsite is for 1 user, some profile data, and their documents. A couple times a year a group of subsites need to have read access for three other employees (3 different per subsite, not 3 for the group of subsites). After about a month, these permissions are removed. This is a very manual process. This system needs to be converted to SPO, but subsites are not permitted and since the subsite template may change, does not seem appropriate. My process has been to create a record per user, linked to a folder per user and accessed via a PowerApp. I have some workflows to help manage permissions, but it’s not comprehensive yet. I’m interested in finding out how someone else would tackle this migration, keeping in mind that ultimately it is managed by non-tech HR staff. Thank You!  Read More

​

Has anybody else run into this? I opened a ticket because comments were being suppressed even if there were 10+ respondents when using ‘Question Response’ filters. Our threshold is 10. The engineering team said that ‘Question Response’ threshold are always 20 for comments regardless thresholds set in configuration. Why would the threshold configuration work for some filters but not others?! I can’t find documentation either. Anyone else? 

​Has anybody else run into this? I opened a ticket because comments were being suppressed even if there were 10+ respondents when using ‘Question Response’ filters. Our threshold is 10. The engineering team said that ‘Question Response’ threshold are always 20 for comments regardless thresholds set in configuration. Why would the threshold configuration work for some filters but not others?! I can’t find documentation either. Anyone else?   Read More

​

Hello everyone: new here Thanks in advance

Goal: I need to return the latest date a manager co-travelled with a Sales Rep.

I created a basic calendar, stating in Cell A3 I put all calendar dates running down column A.  I then have 13 reps starting in cell B2 – N2 (running across row 2).  All of the cells within are drop down menus containing the names of the same 5 managers.  

I need to know when the last time a manager co-travelled with a Sales Rep.  Knowing that a manager can co-travel with a single rep more then one time through out the year.

Thoughts?

Thanks

Steve

​Hello everyone: new here Thanks in advance Goal: I need to return the latest date a manager co-travelled with a Sales Rep. I created a basic calendar, stating in Cell A3 I put all calendar dates running down column A.  I then have 13 reps starting in cell B2 – N2 (running across row 2).  All of the cells within are drop down menus containing the names of the same 5 managers.   I need to know when the last time a manager co-travelled with a Sales Rep.  Knowing that a manager can co-travel with a single rep more then one time through out the year. Thoughts? ThanksSteve  Read More

​

We need a trigger to be sent out if ProcessSchedule has had an INERT, UPDATE or DELETE

We don’t need details just a heads up type of email.

The send email part is easy.

EXEC msdb.dbo.sp_send_dbmail @profile_name = ‘SQLMail’
,@recipients = ’email address removed for privacy reasons’
,@body = ‘Press Schedule Changed’
,@subject = ‘Press Schedule Changed’

The trigger part I have not done before.

Any help would be greatly appreciated.

​We need a trigger to be sent out if ProcessSchedule has had an INERT, UPDATE or DELETE We don’t need details just a heads up type of email.The send email part is easy. EXEC msdb.dbo.sp_send_dbmail @profile_name = ‘SQLMail’,@recipients = ’email address removed for privacy reasons’,@body = ‘Press Schedule Changed’,@subject = ‘Press Schedule Changed’ The trigger part I have not done before.Any help would be greatly appreciated.    Read More

​

I am looking for a way to list all users that are not in 8 specific distribution lists.

I have found an option that gets close but it is not correct.

I only want to display the users that are not in list 1, or list 2, or list 3, or list 4, or list 5 or list 6 or, list 7, or list 8.

The script I found does not appear to apply the “or” to the query.

I also need it to export to a file rather than display on the screen.

Here is a copy of the syntax I found.

$Users = Get-Mailbox | ? {$_.PrimarySmtpAddress -like “*MyDomain.com”} #Enter your domain
$DistributionGroups = @(“List 1″,”List 2″,”List 3″,”List 4″,”List 5″,”List 6″,”List 7″,”List 8”) #Enter names of your distributiongroups

foreach($DistributionGroup in $DistributionGroups)
{
$DistributionGroupMembers = Get-DistributionGroupMember $DistributionGroup

foreach($User in $Users)
{
foreach($DistributionGroupMember in $DistributionGroupMembers)
{
if($DistributionGroupMember.PrimarySmtpAddress -ne $User.PrimarySmtpAddress)
{
Write-Host “$($User.PrimarySmtpAddress) missing in $DistributionGroup” #Export output here fx.
}
}
}
}

​I am looking for a way to list all users that are not in 8 specific distribution lists.I have found an option that gets close but it is not correct.I only want to display the users that are not in list 1, or list 2, or list 3, or list 4, or list 5 or list 6 or, list 7, or list 8.The script I found does not appear to apply the “or” to the query.I also need it to export to a file rather than display on the screen.Here is a copy of the syntax I found. $Users = Get-Mailbox | ? {$_.PrimarySmtpAddress -like “*MyDomain.com”} #Enter your domain$DistributionGroups = @(“List 1″,”List 2″,”List 3″,”List 4″,”List 5″,”List 6″,”List 7″,”List 8”) #Enter names of your distributiongroupsforeach($DistributionGroup in $DistributionGroups){$DistributionGroupMembers = Get-DistributionGroupMember $DistributionGroupforeach($User in $Users){foreach($DistributionGroupMember in $DistributionGroupMembers){if($DistributionGroupMember.PrimarySmtpAddress -ne $User.PrimarySmtpAddress){Write-Host “$($User.PrimarySmtpAddress) missing in $DistributionGroup” #Export output here fx.}}}}  Read More

​

Hi All, 

I have created a spreadsheet showing all frequent costs of my company which has columns for frequency, date and description.

On my second sheet I have the dates for 6 months across the top row and the frequency and description in the first column.

To populate the data in the first month I have input a simple SUMIF based on the date and the description of my frequent cost sheet.

For the following 11 months, I wanted to do a SUMIF based on the date in the first month.

For example:

SUMIF(AA$2:BE$2,EDATE(BF$2,-1),AA12:BE12),0)

AA$2:BE$2 are my date rows (range)

BF$2 is my current date (criteria)

AA12:BE12 are my costs (sum range) the issue I’m running into is if there is a cost on the 31st August, it will not pick it up on the 30th September. 

Any idea how to fix this?

Thanks

​Hi All, I have created a spreadsheet showing all frequent costs of my company which has columns for frequency, date and description.On my second sheet I have the dates for 6 months across the top row and the frequency and description in the first column. To populate the data in the first month I have input a simple SUMIF based on the date and the description of my frequent cost sheet. For the following 11 months, I wanted to do a SUMIF based on the date in the first month.For example:SUMIF(AA$2:BE$2,EDATE(BF$2,-1),AA12:BE12),0)AA$2:BE$2 are my date rows (range)BF$2 is my current date (criteria)AA12:BE12 are my costs (sum range) the issue I’m running into is if there is a cost on the 31st August, it will not pick it up on the 30th September.  Any idea how to fix this? Thanks  Read More

​