Transaction security policy for multiple logins

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;







up vote
2
down vote

favorite












I need to modify the existing transaction security policy to trigger if user logs in from multiple IP addresses in past 8 hours. I'm using the below SFDC example policy. Can someone give a hand on how to tweak the below code to trigger for 8 hours. Currently the policy is configured to trigger for past 24 hours. 



global class LoginPolicyCondition implements TxnSecurity.PolicyCondition 
 public boolean evaluate(TxnSecurity.Event e) 
 AggregateResult results = [SELECT SourceIp
 FROM LoginHistory
 WHERE UserId = :e.userId
 AND LoginTime = LAST_N_DAYS:1
 GROUP BY SourceIp];
 if(!results.isEmpty() && results.size() > 1) 
 return true;
 
 return false;





transaction shield







share|improve this question





















  • This is mostly identical to this question but with more context. Please edit your questions to expand on them rather than creating duplication.
    – David Reed
    4 hours ago










  • David - I deleted the identical question since it was duplicate as you pointed. Thanks
    – VBALearner
    4 hours ago
















up vote
2
down vote

favorite












I need to modify the existing transaction security policy to trigger if user logs in from multiple IP addresses in past 8 hours. I'm using the below SFDC example policy. Can someone give a hand on how to tweak the below code to trigger for 8 hours. Currently the policy is configured to trigger for past 24 hours. 



global class LoginPolicyCondition implements TxnSecurity.PolicyCondition 
 public boolean evaluate(TxnSecurity.Event e) 
 AggregateResult results = [SELECT SourceIp
 FROM LoginHistory
 WHERE UserId = :e.userId
 AND LoginTime = LAST_N_DAYS:1
 GROUP BY SourceIp];
 if(!results.isEmpty() && results.size() > 1) 
 return true;
 
 return false;





transaction shield







share|improve this question





















  • This is mostly identical to this question but with more context. Please edit your questions to expand on them rather than creating duplication.
    – David Reed
    4 hours ago










  • David - I deleted the identical question since it was duplicate as you pointed. Thanks
    – VBALearner
    4 hours ago












up vote
2
down vote

favorite









up vote
2
down vote

favorite











I need to modify the existing transaction security policy to trigger if user logs in from multiple IP addresses in past 8 hours. I'm using the below SFDC example policy. Can someone give a hand on how to tweak the below code to trigger for 8 hours. Currently the policy is configured to trigger for past 24 hours. 



global class LoginPolicyCondition implements TxnSecurity.PolicyCondition 
 public boolean evaluate(TxnSecurity.Event e) 
 AggregateResult results = [SELECT SourceIp
 FROM LoginHistory
 WHERE UserId = :e.userId
 AND LoginTime = LAST_N_DAYS:1
 GROUP BY SourceIp];
 if(!results.isEmpty() && results.size() > 1) 
 return true;
 
 return false;





transaction shield







share|improve this question













I need to modify the existing transaction security policy to trigger if user logs in from multiple IP addresses in past 8 hours. I'm using the below SFDC example policy. Can someone give a hand on how to tweak the below code to trigger for 8 hours. Currently the policy is configured to trigger for past 24 hours. 



global class LoginPolicyCondition implements TxnSecurity.PolicyCondition 
 public boolean evaluate(TxnSecurity.Event e) 
 AggregateResult results = [SELECT SourceIp
 FROM LoginHistory
 WHERE UserId = :e.userId
 AND LoginTime = LAST_N_DAYS:1
 GROUP BY SourceIp];
 if(!results.isEmpty() && results.size() > 1) 
 return true;
 
 return false;





transaction shield




transaction shield






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked 5 hours ago









VBALearner

112




112











  • This is mostly identical to this question but with more context. Please edit your questions to expand on them rather than creating duplication.
    – David Reed
    4 hours ago










  • David - I deleted the identical question since it was duplicate as you pointed. Thanks
    – VBALearner
    4 hours ago
















  • This is mostly identical to this question but with more context. Please edit your questions to expand on them rather than creating duplication.
    – David Reed
    4 hours ago










  • David - I deleted the identical question since it was duplicate as you pointed. Thanks
    – VBALearner
    4 hours ago















This is mostly identical to this question but with more context. Please edit your questions to expand on them rather than creating duplication.
– David Reed
4 hours ago




This is mostly identical to this question but with more context. Please edit your questions to expand on them rather than creating duplication.
– David Reed
4 hours ago












David - I deleted the identical question since it was duplicate as you pointed. Thanks
– VBALearner
4 hours ago




David - I deleted the identical question since it was duplicate as you pointed. Thanks
– VBALearner
4 hours ago










1 Answer
1






active

oldest

votes

















up vote
2
down vote













There is no SOQL Date Literal equivalent to to LAST_N_DAYS:1 that will give you a period of 8 hours.



Instead, you can just calculate the date range and use that in the SOQL query instead.



DateTime eightHoursAgo = DateTime.now().addHours(-8);
AggregateResult results = [SELECT SourceIp
 FROM LoginHistory
 WHERE UserId = :e.userId
 AND LoginTime >= :eightHoursAgo
 GROUP BY SourceIp];
return (!results.isEmpty() && results.size() > 1);





share|improve this answer




















  • That makes perfect sense. Appreciate your help on this.
    – VBALearner
    4 hours ago











Your Answer








StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "459"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













 

draft saved


draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f238557%2ftransaction-security-policy-for-multiple-logins%23new-answer', 'question_page');

);

Post as a guest

















1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes








up vote
2
down vote













There is no SOQL Date Literal equivalent to to LAST_N_DAYS:1 that will give you a period of 8 hours.



Instead, you can just calculate the date range and use that in the SOQL query instead.



DateTime eightHoursAgo = DateTime.now().addHours(-8);
AggregateResult results = [SELECT SourceIp
 FROM LoginHistory
 WHERE UserId = :e.userId
 AND LoginTime >= :eightHoursAgo
 GROUP BY SourceIp];
return (!results.isEmpty() && results.size() > 1);





share|improve this answer




















  • That makes perfect sense. Appreciate your help on this.
    – VBALearner
    4 hours ago















up vote
2
down vote













There is no SOQL Date Literal equivalent to to LAST_N_DAYS:1 that will give you a period of 8 hours.



Instead, you can just calculate the date range and use that in the SOQL query instead.



DateTime eightHoursAgo = DateTime.now().addHours(-8);
AggregateResult results = [SELECT SourceIp
 FROM LoginHistory
 WHERE UserId = :e.userId
 AND LoginTime >= :eightHoursAgo
 GROUP BY SourceIp];
return (!results.isEmpty() && results.size() > 1);





share|improve this answer




















  • That makes perfect sense. Appreciate your help on this.
    – VBALearner
    4 hours ago













up vote
2
down vote










up vote
2
down vote









There is no SOQL Date Literal equivalent to to LAST_N_DAYS:1 that will give you a period of 8 hours.



Instead, you can just calculate the date range and use that in the SOQL query instead.



DateTime eightHoursAgo = DateTime.now().addHours(-8);
AggregateResult results = [SELECT SourceIp
 FROM LoginHistory
 WHERE UserId = :e.userId
 AND LoginTime >= :eightHoursAgo
 GROUP BY SourceIp];
return (!results.isEmpty() && results.size() > 1);





share|improve this answer












There is no SOQL Date Literal equivalent to to LAST_N_DAYS:1 that will give you a period of 8 hours.



Instead, you can just calculate the date range and use that in the SOQL query instead.



DateTime eightHoursAgo = DateTime.now().addHours(-8);
AggregateResult results = [SELECT SourceIp
 FROM LoginHistory
 WHERE UserId = :e.userId
 AND LoginTime >= :eightHoursAgo
 GROUP BY SourceIp];
return (!results.isEmpty() && results.size() > 1);






share|improve this answer












share|improve this answer



share|improve this answer










answered 5 hours ago









Daniel Ballinger

70.8k15145377




70.8k15145377











  • That makes perfect sense. Appreciate your help on this.
    – VBALearner
    4 hours ago

















  • That makes perfect sense. Appreciate your help on this.
    – VBALearner
    4 hours ago
















That makes perfect sense. Appreciate your help on this.
– VBALearner
4 hours ago





That makes perfect sense. Appreciate your help on this.
– VBALearner
4 hours ago


















 

draft saved


draft discarded















































 


draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f238557%2ftransaction-security-policy-for-multiple-logins%23new-answer', 'question_page');

);

Post as a guest
































































Comments

Post a Comment

Popular posts from this blog

What does second last employer means? [closed]

Image
Clash Royale CLAN TAG #URR8PPP .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0; up vote -3 down vote favorite Say, for example I have worked in the following companies, Company A => 2010 - 2011 Company B => 2011 - 2012 Company C => 2012 - Till Date Company D => Have offer Now assume Company D is asking to submit documents from my second last employer. So from the list of companies given, which company would be qualified as second last employer? software-industry employer share | improve this question asked Aug 10 '14 at 5:16 Rajaprabhu Aravindasamy 559 1 6 13 closed as off-topic by Jim G., jmort253 ♦ Aug 11 '14 at 1:58 This question appears to be off-topic. The users who voted to close gave this specific reason: "Questions seeking advice on company-specific regulations, agreements, or policies should be directed to your manager or HR department. Questions that address...
Read more

List of Gilmore Girls characters

Image
The season three cast—(Back row): Lane, Michel, Paris, Emily, Richard, Sookie, Miss Patty, Kirk; Front row: Jess, Luke, Lorelai, Rory, Dean This is a list of characters for the comedy-drama television series Gilmore Girls . Contents 1 Main characters 1.1 Lorelai Gilmore 1.2 Rory Gilmore 1.3 Sookie St. James 1.4 Lane Kim 1.5 Michel Gerard 1.6 Luke Danes 1.7 Emily Gilmore 1.8 Richard Gilmore 1.9 Paris Geller 1.10 Dean Forester 1.11 Jess Mariano 1.12 Kirk Gleason 1.13 Jason Stiles 1.14 Logan Huntzberger 2 Major recurring characters 2.1 Christopher Hayden 2.2 Jackson Belleville 2.3 Mrs. Kim 2.4 Tristin DuGray 2.5 Max Medina 2.6 Taylor Doose 2.7 Dave Rygalski 2.8 Marty 3 Recurring characters 3.1 Stars Hollow 3.2 Chilton 3.3 Yale 3.4 Other 4 Notable guest stars 5 Unseen characters 6 Notes 7 References Main characters Actor Character Appearances Season 1 Season 2 Season 3 Season 4 Season 5 Season 6 Season 7 A Year in the Life Lauren Graham Lorelai Gilmore...
Read more

Confectionery

Image
Prepared foods made with a lot of sugar or other cabohydrates "Sweetmeat" redirects here. For the racehorse, see Sweetmeat (horse). Not to be confused with Sweetbread. This Kransekake is a traditional Scandinavian baker's confection. Confectionery is the art of making confections , which are food items that are rich in sugar and carbohydrates. Exact definitions are difficult. [1] In general, though, confectionery is divided into two broad and somewhat overlapping categories, bakers' confections and sugar confections. [2] Bakers' confectionery, also called flour confections , includes principally sweet pastries, cakes, and similar baked goods. Sugar confectionery includes candies ( sweets in British English), candied nuts, chocolates, chewing gum, bubble gum, pastillage, and other confections that are made primarily of sugar. In some cases, chocolate confections (confections made of chocolate) are treated as a separate category, as are sugar-free versions of ...
Read more