Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-08-2018 11:08 PM
I have about 1000 PCs im trying to report on. In Custom Field 1 ive renamed it to EOL (End of Life) in Date format. The point of this is for me to build a report to determine which PCs I need to replace each month. Could someone assist in helping me build a report to tell me if any PCs dont have the the date inputted yet and also a report with a list of PCs with it inputted? I keep attempting to build one but im not getting the data im looking for.
Thank you for your time.
Thank you for your time.
Labels:
- Labels:
-
Report Center
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-09-2018 12:20 AM
show us a sample of a report you tried?
you probably need (tblassetcustom.custom1 is NULL) in your where clause to get you the ones that have no value.
you may also need something like this to weed out whitespace versus null
SELECT column_name
FROM table_name
WHERE TRIM(column_name) IS NULL
older versions of sql were LTRIM() or RTRIM() if I recall.
you probably need (tblassetcustom.custom1 is NULL) in your where clause to get you the ones that have no value.
you may also need something like this to weed out whitespace versus null
SELECT column_name
FROM table_name
WHERE TRIM(column_name) IS NULL
older versions of sql were LTRIM() or RTRIM() if I recall.