Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [query]

196 questions
1
vote
0 answers

SCCM collection evaluates major version numbers in unexpected way

Why do SCCM collections based upon the logic Installed Applications (64).Version is less than "100.0" not evaluate to true for applications of version 99.* and below? The full WQL query statement is as follows, (linebreaks for legibility) select…
branpurn
  • 11
  • 1
1
vote
1 answer

AWS Athena Query 2 separate tables together

I have 2 Tables, and i need to query them together, for example. From the first table i get results with my query: InstanceID, title, status and etc... From the second one: key, value, region and etc... I want to make 1 query so i can get the…
hightest
  • 131
  • 1
  • 2
  • 5
1
vote
0 answers

Alternate method for caching mysql query (query_cache) on version above 8.0

On mysql version 8+ the query_cache support was removed. I know why it is not a friendly thing with InnoDB when considering the CPU. But I've some databases which really need this support where user repeat the same query in most cases. Is it…
TELA
  • 33
  • 5
1
vote
1 answer

Optimizing MariaDB Performance

I need a different set of eyes checking my MariaDB settings. During peak load times, the CPU can hit upwards of 600% or more, and slows down Wordpress application. I have used MySQLTuner to tweak a few settings. Server is Debian 10.7, 32GB Ram, 8…
Infinixd
  • 11
  • 1
  • 2
1
vote
2 answers

select values must match the number of insert columns

I have the following query... ive checked and rechecked the types and number of values in both the insert into and the select statements. I can't figure out what is wrong. insert into [Subscription].dbo.SUBSCRIPTION ( CreateDate, …
Rod Johnson
  • 453
  • 1
  • 4
  • 7
1
vote
1 answer

Azure : How to process Azure Log events from Event hub and filter based on criteria

How to process Azure Log events from Event hub and filter based on criteria. We are trying to filter specific critical or security related Diagnostic and Activity logs before feeding into our Onprem SIEM solution. Can someone please guide me how to…
Anil Kash
  • 11
  • 1
0
votes
1 answer

How to use variables in inner queries?

I am trying to build a query that has something like this select id, (select top 1 create_date from table2 where table1id = t1.id and status = 'success') [last_success_date], (select count(*) from table2 …
Rod Johnson
  • 453
  • 1
  • 4
  • 7
0
votes
1 answer

Querying Exchange 2003 for Information About Attachments

I'm looking into the possibility of switching from Microsoft Office to Google Apps. Although Google Apps are not currently as feature rich as the Microsoft Product, the Google tools provide greater colloboration support (online sharing and editing,…
cb160
  • 103
  • 1
0
votes
2 answers

Show any null value?

is there a SQL statement that would show any null value in any record? For example if I had a table Alpha with Column A, B, and C where C was null in one record, and B was null in another, and A in another. Could I select only the rows that contain…
Michael Erickson
0
votes
5 answers

What is faster for reading: SQL CE or file on the disk?

On my server side I need to store user data somehow. Some time ago I used to use INI files for writing and reading those values. Even with tousands of files it was incredibly fast (ms), maybe due to caching. Recently I am considering some DB but I…
Tomas
0
votes
2 answers

MySQL query is very slow over internet

I'm having an issue with a very slow query in an C# WPF application. The application connects to a MySQL-server. As long as the application is used on my LAN, everything is going fast. When i use the application anywhere else, connecting to the DB…
Dave
  • 1
  • 2
0
votes
2 answers

Nginx rewrite query url, redirect and serve content

Apache user here so not very familiar with nginx :) Eg url like this testpage.no/products?test_category=434 How to redirect this url and its content to this url: testpage.no/testcategory is this correct way if not what am I missing: location /…
Trenox
  • 101
0
votes
2 answers

Exchange 2016 New-Mailboxsearch KQL Query Help - Is this possible? (X or Y) not (Z unless also X)

Thanks in advance for reading & any help you can provide!   I'm trying to do a mailbox search against several mailboxes. I need to find all messages that mention some words AND don't mention other words EXCEPT when those words are on both lists.…
R_C_III
  • 41
  • 1
  • 1
  • 5
0
votes
1 answer

Access or SQL query to list most recent AutoNumber within a specific Range

I am looking to write a query where it shows me the last 50 of the highest ids, without knowing the most recent id #. The id is an autogenerated primary key. Any help would be appreciated. Maybe I should be more specific. I work for a scheduling…
Michael Erickson
0
votes
1 answer

SCCM WQL Query Structure BIOS release date

So with this whole Meltdown and Spectre causing a huge fuss world wide. I have discovered a solution to mass deploy BIOS updates. The one thing is when checking compliance I am unable to locate anything that is different but the same for all models.…
Eryper
  • 15
  • 5
1 2 3
…
13 14