Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

SWQL joins is breaking a query

cscoengineer

This query works

As soon as I join the containermembers table, it breaks.

the weekdiff refuses to work with the join.

When I migrated the query to SQL, it works with the join.

any ideas?

Thank you,

Amit

Find more posts tagged with

Accepted answers

All comments

Seashore

Tested this out and get the same as you. What confuses me is that it works without join. You are comparing an INT with a Datetime...

jm_sysadmin

Yah, I can confirm it works for me like it works for you. And you definitely pinpointed the issue. I don't know why it accepts 0 in 1 query and not another.

WEEKDIFF(0, GETDATE())

Can you replace the 0 with the start date? I think that will iron it out.

cscoengineer

Not doing any comparison. Just need to get the starting of last week and pull some group member information. WHich is why I need to join it with the containermember.

cscoengineer

didn't work for me

I need to get the group member information for last week (Sunday-Saturday).

Since my method isn't working. Do you know of any other way?

cscoengineer

Got it to work using addday instead of weekdiff

addday(-7,DATETRUNC('week',getdate())) - start of last week

addday(0,DATETRUNC('week',getdate())) - end of last week

thank you,

Amit