Recent content by AirForce

I have a database which includes a date field (5 June 03) and I would like to be able to get a prompt that ask for the month and year. From the information that is given at the prompt, I would like to output all information for the given month and year. Thanks, Newbie

This is a simple query that I'm running. I've also tried with %.exe and I get a couple files. select SMS_R_System.NetbiosName, SMS_G_System_SoftwareFile.FileName from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where...

I tried running a query for %.exe and under the VALUES tab it only goes up to the letter I. I ran the query anyway and got nothing. This is part of a file called SINV32.TXT from one client. ---------------------------------------------------------- AppRegister Software Inventory Agent -...

Thanks for the response. I've checked all my log files but I see no error. Below you will see some messages from the Inventory Processor log. I ran a query to check date of last inventory and it looks OK. For some reason I can't see the data it's collecting if it's actually collecting. I'm...

My SW inventory isn't working. All the clients give a good time and date of last inventory but when I run my query, only 4 clients show with *.txt files. It was working about a month ago but now it's dead. I changed the SW inventory to kick off every hour but it still doesn't work. Also...

When I ran queries a few weeks ago everything worked fine. When I run a query on ".TXT" files I only get results from about 4 computers out of 500. Any suggestions? SQL is running fine. Thanks

I'm getting this error when I try to advertise a program. It's a simple script file that creates local users on a PC. ERROR BELOW: An error occurred while preparing to run the program for advertisement "LG120057" ("LGLOIITM" - "LGLOIITM"). The operating system...

I'm getting error "Unable to connect to APS" everytime I try to open Crystal Reports. Any suggestions? Thanks

Thanks for responding. I looked at one client and the IP was 131.52.30.238 then I check my subnet selection and I had 131.52.30.0 selected. The client software is getting installed and SMS finds it but on the client (Control Panel/System Management/Sites) the Site does not appear. Although...

We installed SMS 2.0 SP1 and we have a couple clients working just fine but the majority of clients are not working. The client software is installed on the computer but under the Microsoft SMS console\collections\all systems the clients appear but the site code is not listed and also under...